Forum Discussion
Peter2023
Helper I
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.g...
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"})
