The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
32 | |
13 | |
10 | |
10 | |
9 |