Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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.
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.
@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.
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.
@Anonymous , then you can use the measure as filter from the fact or facts and check for non blank
Countrows(fact1)+ countrows(fact2)
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.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |