How can we improve Power BI?

Table filter

I'd like to be able to select a record in a table and have a chart on the dashboard filtered by that record. For example in PerformancePoint you can create a KPI list and then have a filter action to filter a line chart by the selected KPI. Ideally it would be good to have something similar to Tableau chart actions where you can customize which charts are affected by the filter, method of activating the action (click, hover etc). I understand this might be complex so I'd settle for a special type of table which restricts you to one dimension and many measures, and clicking on a dimension value would filter all charts on the dashboard.

425 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Tony Gaul shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

52 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Anonymous commented  ·   ·  Flag as inappropriate

    I'd like to be able to filter a table directly, like in Excel, where I can filter each column. Then having filtered the table, select one or more of the remaining rows, and have them slice data that appears in other tables/charts. Call it a "multi-column slicer". Instead of having a separate slicer for each dimension, the multi-column table allows me to search for the combination of dimension values of interest, and then filter the remainder of the report to those dimension values. The latter slicer functionality goes beyond Excels; but we begin with being able to filter individual columns, in the table itself.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Is there a way to turn this off?
    Any time I click on the table to edit it or just because I'm trying to click off of something else, it turns on a filter.
    This needs to be a setting to have row filtering

  • Thyssen Burger commented  ·   ·  Flag as inappropriate

    Hi forum, I am relatively new to PBI and come from a strong Qlikview background. This is definitely a requirement for intuitive filtering and total BI experience. Please try attend to this as a matter of urgency

  • Dan Hartshorn commented  ·   ·  Flag as inappropriate

    Well this has been kicking around for some time. I have a customer that will probably not go this way without the support for this.

  • Marek commented  ·   ·  Flag as inappropriate

    I'm wondering, if anyone from the Power BI team even looked at this one?
    On top of that, I'd like also to be able to select and copy the line/field to clipboard from a table.

  • Steve Ward commented  ·   ·  Flag as inappropriate

    I've just written a year on year comparison to view the top 10 customers from the previous year and the % change to the current year. The results are displayed in a table. Works great. After seeing the results the obvious next step is to click on one of the rows and view the sales info for that particular customer. But it's not possible!
    You have a table visual and a slicer visual - please combine the two.

  • Jakub Naduk commented  ·   ·  Flag as inappropriate

    @Heidi, same here.. We were presenting basic mockup of the template to a customer and one of their first questions was "ok, but what if I would like to select a row on a table and display only that?"...

  • Heidi commented  ·   ·  Flag as inappropriate

    I'm on Day 2 using Power BI and this already came up as an issue for us.

  • Anonymous commented  ·   ·  Flag as inappropriate

    We have a need to select a row and display a long info field in another table to make the data readable.

  • Robin commented  ·   ·  Flag as inappropriate

    Come on chaps! 624 votes and over a year later. It's one of the main reasons people are sticking with Qlikview...

← Previous 1 3

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.