Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |