Skip to main content

Power BI

Needs Votes

Cross filter on a slicer

Vote (65) Share
Kristen's profile image

Kristen on 25 Feb 2016 01:33:45

Would like to cross filter on a slicer.

Comments (5)
Kristen's profile image Profile Picture

S_Patel on 06 Jul 2020 00:08:52

RE: Cross filter on a slicer

Please add the functionality that any object that has been selected should update the filters on the page. This works great in Qlik Sense !

Kristen's profile image Profile Picture

Power BI User on 05 Jul 2020 23:59:07

RE: Cross filter on a slicer

I've a similar request where I have a shape map. I'd like a user to select an area on the map to set the slicer value rather than use a dropdown list to select the region name for example. Selection from the map would be more user friendly.

Kristen's profile image Profile Picture

Fred Kaffenberger on 05 Jul 2020 23:37:30

RE: Cross filter on a slicer

For more context, see this post by Alberto Ferrari: " It would be great if slicer syncing came as a feature in Power BI implemented through specific queries sent by the client tool, so that users would stop using bidirectional relationships for that purpose."

https://www.sqlbi.com/articles/bidirectional-relationships-and-ambiguity-in-dax/

Kristen's profile image Profile Picture

Ron on 05 Jul 2020 22:38:37

RE: Cross filter on a slicer

This needs to be fixed immediately! PLEASE VOTE. Erick is incorrect. The request is to have the CROSS FILTER APPLY TO THE SLICER. For example, I have a bar chart, I need to CROSS FILTER the SLICER so that when I click on a value in the bar chart it applies the CROSS FILTER on the SLICER, thus removing the values that are not related to the selected bar chart value. This should be so simple and yet it is still not available. You can even check the 'Edit Interactions', which shows that is SHOULD be applying the CROSS FILTER to the slicer, but it DOES NOT. Again, you can try and test with something as simple as a few manually entered rows as proof. Please FIX!

Kristen's profile image Profile Picture

Erick Miranda on 05 Jul 2020 22:16:56

RE: Cross filter on a slicer

Just to add more context to this request: if the data source are flat files or a relational database cross filter for slicers work but not if the data source is a tabular or multidimensional cube.