Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I have a hierarchy slicer like below.
I want to remove the empty nodes with no data OR display an alternate text (Data not available) when there is no data in the nodes.
Help is appreciated.
hi @Pallavi_m
you can uncheck the blank items in the filter pane.
about fitler pane:
https://learn.microsoft.com/en-us/power-bi/consumer/end-user-report-filter
but the ultimate solution is to enhance the data model, ensuring all the values present in fact table also present in dimensional table.
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
73 | |
63 | |
61 |