cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wbridwell79
Frequent Visitor

New Native Hierarchy Slicer Blanks

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.
7 REPLIES 7
Super User IV
Super User IV

Re: New Native Hierarchy Slicer Blanks

Can you just use the Filter pane and uncheck blanks?

---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Super User IV
Super User IV

Re: New Native Hierarchy Slicer Blanks

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





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blog -Week is not so Weak Proud to be a Super User! Connect on Linkedin


wbridwell79
Frequent Visitor

Re: New Native Hierarchy Slicer Blanks

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

Re: New Native Hierarchy Slicer Blanks

Hi @wbridwell79 

 

Would you mind trying below the workaround?

1.PNG

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
wbridwell79
Frequent Visitor

Re: New Native Hierarchy Slicer Blanks

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

Re: New Native Hierarchy Slicer Blanks

Hi @wbridwell79 

 

Could you please kindly provide the dummy pbix?

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
wbridwell79
Frequent Visitor

Re: New Native Hierarchy Slicer Blanks

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors