How to remove empty nodes(nodes with no data) from hierarchy filter

[Pallavi_m]

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.

[FreemanZ]

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.