Power BI

Completed

Table filter

Vote (424)

Tony Gaul on 27 Mar 2015 13:36:49

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.

Administrator on 06 Jun 2017 06:57:44

We have this feature in the new table and matrix visual. Learn more in the blog: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/#table

Comments (52)

Comments (52)

9a65852a fa05-4658-9372-c089e2d074ba on 05 Jul 2020 22:42:32

RE: Table filter

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.

e496170a 8cd0-4900-879d-e353ed0e16bc on 05 Jul 2020 22:42:04

RE: Table filter

And I am on day one, and hey, I can't do that ??

e058ea7b 16c7-4b53-becb-cf261b997f2e on 05 Jul 2020 22:40:48

RE: Table filter

'@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?"...