Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |