Forum Discussion
Helper IHow to remove (Blank) in Slicer?
I have the data sample as shown in the file. When I put the hierarchies into the slicer, blank data appears. Is there a way to remove this blank data? Please help.
Sample file: https://drive.google.com/file/d/1XAmEAnBgzcnJ9uNh8EvNptX30lJNwEIu/view?usp=sharing
Peter2023 , You might have to use hierarchy slicer. as explained
https://radacad.com/removing-blanks-from-organizational-ragged-hierarchy-in-power-bi-matrix-visual/
For that you have all "null" as null/blankI added a step for that
= Table.ReplaceValue(#"Changed Type","null",null,Replacer.ReplaceValue,{"L1", "L2", "L3", "L4", "L5"})
9 Replies
- amitchandak
Super User
Peter2023 , One of the ways is to use a visual level filter and remove blanks
Also check why we have blanks -https://www.youtube.com/watch?v=23qemkDqMVY
Peter2023Could you please explain more? i know why have blanks but i have no idea to solve it.
- amitchandak
Peter2023 , You might have to use hierarchy slicer. as explained
https://radacad.com/removing-blanks-from-organizational-ragged-hierarchy-in-power-bi-matrix-visual/
For that you have all "null" as null/blankI added a step for that
= Table.ReplaceValue(#"Changed Type","null",null,Replacer.ReplaceValue,{"L1", "L2", "L3", "L4", "L5"})
- Peter2023
if filter , TX part will be disappeared
- Ahmedx
you need used power query
pls try- Peter2023
Thank you for the support, but it does not match my expectations yet. I want it to be branched so that I can see which parts are smaller components and which larger parts they belong to.
- Peter2023
please help. thank you.
