Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hi
I have a slicer within my Power BI report which has a 3 field hierarchy.
The 3rd field hierarchy has (blank) options which I do not want the user to see or pick.
Is it possible to exclude the (blanks) from the slicer hierarchy?
Thanks
Solved! Go to Solution.
@Dev-13 , if they are from different tables, you can have visual filter to ignore blank
but if they are same table removing that can remove above levels too
It's from a data model, so when you apply the visual filter it removes the other levels too
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
12 | |
10 | |
10 | |
9 |
User | Count |
---|---|
17 | |
14 | |
12 | |
11 | |
10 |