Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How can I sync the slicers between 2 pages, where I'm filtering the values of slicer on one page using measure & on the other page, slicer should show all the values
Solved! Go to Solution.
@Anonymous Yeah, that is correct, I forgot, you can't use measures in page level filters. I don't think there is a solution then. Not any that I can think of.
@Anonymous , Under the view Tab in the desktop you have an option for Sync Slicer. Are you looking for that
@amitchandak I'm looking for a way to sync the filters, and change the values shown in the filter according to page. In one page I want to show all the values that are present in the field which is creating the slicer, whereas on the other page I want to show only those values whose which are satisfying the condition.
For example, my slicers are using [category] field which contains values cat1, cat2, cat3, ..., cat10
I'm using this slicers on 2 pages, page1 & page2
On page1, I want to show all the values,
whereas for page2, I have a [measure]=if(selectedvalue([category]="cat1",1,if(selectedvalue([category]="cat2",1,0)). I want to show only those values on the slicer, for which [measure]=1,
and I don't want this measure to work on page1
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
@Anonymous I'm not sure what you desire is possible with sync slicers. What you want is kind of the opposite of sync slicers to a degree. But, have you tried a page level filter with your measure? On your 2nd page.
@Greg_Deckler I have tried to use measure on filter on this page section, but I am not able to do so, since when I'm trying to drag and drop measure on filter on this page section, the measure is not coming up in the filter. If it is possible to apply measure on filter on this page section, then my issue will be resolved
@Anonymous Yeah, that is correct, I forgot, you can't use measures in page level filters. I don't think there is a solution then. Not any that I can think of.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.