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.
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.
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.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
At the monthly call, connect with other leaders and find out how community makes your experience even better.
Click here to read more about the May 2022 updates!