Earn 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 |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |