How to remove (Blank) in Slicer?

[Peter2023]

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]

please help. thank you.

[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.

[rohit1991]

Hii @Peter2023 

Simple way to remove NULL: go to the Filters pane → Advanced filtering → set “does not contain” → type (null)→ Apply filter.

[Peter2023]

if filter , TX part will be disappeared 

[amitchandak]

@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

[Peter2023]

Could you please explain more? i know why have blanks but i have no idea to solve it.

[amitchandak · Accepted solution]

@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"})

[Peter2023]

Thank you, hierarchy slicer is perfect. Everything is working now.
But any way if not use custom visual?