Forum Discussion
Adding a Hierarchy on Filter Pane
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.
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.
6 Replies
- amitchandak
Super User
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.
- amitchandak
Anonymous , then you can use the measure as filter from the fact or facts and check for non blank
Countrows(fact1)+ countrows(fact2)
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.
