powerbidaxvisualizationpowerbi-desktopmeasure

How to remove visualization of blank sublevel in slicers


I wuold like to know whether there is a way in Power BI to exclude visualization of each sublevel in the slicer you can see on the right of picture. I am just interested to remove the Blank sublevel, eventhough in the respective column of the table on the rught the column is empty. Is there any way to do this?

enter image description here

Thanks


Solution

  • This is known as a ragged hierarchy. To fix, you can use a custom slicer which supports ragged hierarchies (e.g. https://xviz.com/blogs/ten-reasons-to-use-hierarchy-filter-slicer-power-bi-dashboard/) or implement some very complex DAX to suppress them: https://www.daxpatterns.com/parent-child-hierarchies/