Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@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
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |