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?
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/