Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi All!
I have a question regarding, I think, switching/slicing Attributes, let me explain.
I've made an example file.
1) Let's say I have a set of SKUs, that are united into Categories and Groups (Picture 1)
2) I switch to Category 1 and Group 1, everything works fine (Picture 2).
3) And now the interesting part begins: I want to switch to Category 2. I check it and everything dissapears. And that is alright, there is no SKUs that are both Category 2 and Group 1. Group 1 stayed checked (Picture 3).
4) But I want to see something in this situation: I want to manage it. I want it this way: When I change the Category, the Group should clear its filter, or switch only top3 or something. How can I do it?
Hierarchy Slicer is not a good option, because it can be very many groups and subgroups.
Thank You very much for your help!
@Anonymous this is a known functionality, unfortunately, you cannot clear the slicer values and if a category doesn't have a previously selected group, it will show up in the group list as selected option and use have to manually clear it. I think there is an idea on this on ideas forum, please vote for it.
I would 💖 Kudos 🙂 if my solution helped.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi! Thank You for Your help!
Could You please link that topic, So i could vote? I didn't find it 😞
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |