Forum Discussion
How to remove (Blank) in Slicer?
- 9 months ago
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 , 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/blank
I added a step for that
= Table.ReplaceValue(#"Changed Type","null",null,Replacer.ReplaceValue,{"L1", "L2", "L3", "L4", "L5"})
Thank you, hierarchy slicer is perfect. Everything is working now.
But any way if not use custom visual?