Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
Hi there,
I'm trying to make a hierarchy slicer and hide the empty members so only parent filters with children filters have the little arrow next to them to drop-down. I figured out how to do this in Hierarchy Slicer visual rather than a normal Slicer visual.
However, I want the Hierarchy Slicer to appear as a drop-down menu to select from, rather than a list (see images for what it currently looks like, and what I want it to look like). I haven't been able to find any tutorials on this. Please help!
This hierarchy slicer needs to be condensed down into a drop-down menu rather than a list.
This is the normal slicer I have, and how I want the hierarchy slicer to look .
anyone found a solution for this?
@sknudson -> if that doesn't work then use native hierarchy slicer. Refer the link below:
Hi @truptis
Unfortunately, it doesn't look like that works for Hierarchy Slicers. There is no arrow to select between list or drop down like a normal slicer.
I chose Hierarchy Slicer instead of a normal slicer because I can hide the empty members.
This is unique to Hierarchy Slicer visuals.
Would you alternatively know how to hide empty members of a normal slicer? I haven't been able to find the same options (see image of regular slicer formatting options).
@sknudson , you that arrow drop down, you need to turn ON the "slicer header"
Currently in the screenshot provided by you it is OFF.
So, turn it on & then you will see that small drop down arrow. Then select Drop down.
Mark it as a solution & hit the thumbs up if it helps you. Thanks.
@sknudson - got u!
This slicer can still be formatted as a drop down or changed to be single select. The single select allows a whole level of the hierarchy to be selected such as the whole types of resources or entire resource.
My goal is to format the hierarchy slicer to look like the following image.
Note: this is the normal slicer without the functionality of the hierarchy slicer visual I am creating.
I still want the functionality of the slicer to be multi-select, and to have the option for each of the 'child' filters to work. I just want the overall format of the slicer to look like the above image rather than a list that is bulky and in the way.
Hi @sknudson , Were you able to solve this? I am in need in need of similar slicer, wondering if you found any solution.
Hi @Anonymous and @sknudson, did you guys find a solution to this? i need to create a slicer with similar requirements.
HI @sknudson,
I think the hierarchy slicer does not support switching to dropdown modes as a normal slicer.
Perhaps you can contact the visual author to add support with dropdown mode.
Regards,
Xiaoxin Sheng
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 76 | |
| 36 | |
| 31 | |
| 29 | |
| 26 |