New Native Hierarchy Slicer Blanks

[wbridwell79]

Can anyone help me with how to handle blanks with the native hierarchy slicer? With the old custom hierarchy slicer there’s simply a toggle button to ignore blanks.

[Anonymous]

Did you find a solution for this? I'm facing the same issue, any insight is greatly appreciated, thanks!

[wbridwell79 · Accepted solution]

Here is the solution to this that I discovered about a year ago.  Measure = INT ( NOT ISEMPTY('Table Name you're slicing')).  Put this measure as a visual level filter and set it as "is not"  0  and apply filter.

[v-diye-msft]

Hi @wbridwell79 

Would you mind trying below the workaround?

[wbridwell79]

No luck. I’ve tried everything imaginable using the filter pane. Have to find a DAX way to do it I guess.

[v-diye-msft]

Hi @wbridwell79 

Could you please kindly provide the dummy pbix?

[wbridwell79]

@v-diye-msft https://www.dropbox.com/s/3du9ks2ef5ebcq0/HierarchySlicer_Example.pbix?dl=0

[amitchandak]

Refer to the section of hierarchical slicer in https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-2020-feature-summary/

[Greg_Deckler]

Can you just use the Filter pane and uncheck blanks?

[wbridwell79]

Greg, when I tried that it also removed thE parent level if it only had blanks.