Forum Discussion
Helper IHow to remove (Blank) in Slicer?
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"})
Super UserPeter2023 , 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
Helper ICould 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
Thank you, hierarchy slicer is perfect. Everything is working now.
But any way if not use custom visual?