The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
14 | |
12 | |
8 | |
6 | |
5 |
User | Count |
---|---|
28 | |
19 | |
13 | |
7 | |
5 |