cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aphilliott Occasional Visitor
Occasional Visitor

Re: how to remove the null/blank from a slicer?

I second this question.

Super User
Super User

Re: how to remove the null/blank from a slicer?

The answer is no. A slicer is a filter, so hiding something from the slicer is filtering it. If it is deselected in the slicer, by definition it is filtered out. If it isn't shown in the slicer, it can't be selected. So hiding and filtering are the same thing.

ctowery Frequent Visitor
Frequent Visitor

Re: how to remove the null/blank from a slicer?

This needs to be added back to Power BI functionality.

Report and page data needs to show the values within the BLANK record but the Slicer needs to have BLANK removed.

 

BLANK anywhere gives the user digesting the data a sense of doubt in the accuracy.

 

I've had to use the +0 method in almost all of my visuals in all of my Power BI projects and this is another instance where it's causing extra work for me.

sotoc Regular Visitor
Regular Visitor

Re: how to remove the null/blank from a slicer?

I've worked around this by using a table instead, using your field as the Values. You can format the table to make it look like a list and add a title or change your column name to something akin to "Choose a Category." Unfortunately the check box wouldn't be available. 

 

https://www.dropbox.com/s/u5jxwkj8t3azbuy/Slicer_Example.jpg?dl=0

akhachaturyan Frequent Visitor
Frequent Visitor

Re: how to remove the null/blank from a slicer?

Another way to get rid of the "(Blank)" is to:

  1. Choose "Advanced filtering" from the "Page level filters"
  2. Choose "is not blank" from the "Show items when the value:" dropdown.
deepu299 Member
Member

Re: how to remove the null/blank from a slicer?

I have did a work around to hide BLANKS from the slicers only. This might not work for dynamic slicer values, in my case the  slicer values will not change.  I had to duplicate the slicer, select all values except Blank and hide the slicer. With Edit interactions options, I have turned off everything from this slicer but the original slicer so other visuals are not impacted by removing the blank values. 

aswinrhs Frequent Visitor
Frequent Visitor

Re: how to remove the null/blank from a slicer?

This for the suggestion..this worked like a charm..Kudos!

Highlighted
sca4TVD Frequent Visitor
Frequent Visitor

Re: how to remove the null/blank from a slicer?

Kudos to you

You saved my day