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.
Hello
I have a report where I have slicers for "Category" and "SubCategory".
So, if I select a category in 1st slicer and then subcategory in 2nd slicer, I see the data.
Now when I select a different category in 1st slicer, my 2nd slicer still have the Subcategory from old category. How do I make my 2nd slicer to "clear all" itself if I change the Category.
Screenshots below -
Regards
Solved! Go to Solution.
Hi vmakhija,
I have attached PBIX file here, please check if it can be downloaded in your work place.
Regards,
Jimmy Tao
I just came across the same issue. The only thing I found was to download one of the slicer visuals. The attribute slicer by microsoft seems to work. I dont know why they dont fix the standard slicer.
Hi, can you explain how the "Attribute slicer' works for your case, I downloaded it and it behaves the same as the standard slicer.
It is your answer that should be marked as a solution ! Indeed, dowloading the Microsoft visual "Attibute slicer" solved the problem. Thanks a lot !
Seems like this still hasn't been officialy solved. The fastest and easiest solution I went for, was affing a "clear all slices button". I orignally thought about creating a boormark and use it in a button but then discovered there is an in built one that does exactly this, which I think was created exactly for this reason. Not the best solution, especially if you have multiple subcategories and want to mantain the first filter, but it works.
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.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |