Adding a Hierarchy on Filter Pane

[Anonymous]

Hello,

I want to place a hierarchy filter in the Filters pane on Power BI, but I am cannot.

I can create a hierarchy slicer on the report, but I'd like to place the filter on the Filters pane instead. Is this possible?

I would need to filter out blank values from the name in the hierarchy.

This is an example. I want to filter out the lines with red cross. I cannot use one column from the hierarchy because I might filter out a record that I need in another drill down. The hierarchy I have is a bit inconsistent, and I need to find a way to work around it. 

[Anonymous · Accepted solution]

Hello,

I was able to find a solution.

This is the video: https://www.youtube.com/watch?v=YEuxONjCl1A 

There is also a comment, where someone is explaining how to do it for multiple levels.

[amitchandak]

@Anonymous , after you added all the levels in the slicer, use a visual level filter to remove blank values. Check for values not is blank.

[Anonymous]

Hello Amit,

Even if my value is blank, sometimes I would need to keep the row. If there is a name for this row, I need to keep it even if the value is blank.

[amitchandak]

@Anonymous , then you can use the measure as filter from the fact or facts and check for non blank

Countrows(fact1)+ countrows(fact2)

[Anonymous]

Hey @amitchandak,

thanks. Its still not solving my problem. I need to filter on the hierarchy column itself or figure out a way where I can filter using the hierarchy colunm.