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

Removing Values from Slicers

Is there a way to hide the blank values but not filter out the data? 

 

For example:

 

I have a column with binary values "Yes" or "No" but I want the slicer to just have the "yes" option showing. I do not want to filter out the NO data though. So the slicer would be selecting either ALL DATA or Data with YES in that column. I can elaborate if needed! Please help Smiley Sad 

 

This thread below teaches how to filter out blank values but I want to keep the data so it does not apply to my situation. 

 

https://community.powerbi.com/t5/Desktop/how-to-remove-the-null-blank-from-a-slicer/m-p/370925#M1681...

10 REPLIES 10
SivaMani Senior Member
Senior Member

Re: Removing Values from Slicers

@dillonfarrar,

of course. There is a way to do this.

 

  1. Create another slicer with the same field
  2. Select values which you want to display. In your case, select yes
  3. Hide the slicer: Option available in Selection Pane

Let me if you need any other help:) 

Community Support Team
Community Support Team

Re: Removing Values from Slicers

@dillonfarrar,

 

Drag field from table below and add a measure to filter the data.

Table =
ROW ( "Flag", "Yes" )
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dillonfarrar Frequent Visitor
Frequent Visitor

Re: Removing Values from Slicers

Hey SivaMani,

 

This filters out data that I need in my report though. All I want is a way to filter out slicer options without actually removing the data. 

 

Just want to be able to hide a value in a slicer without actually filtering out the data. The Slicer currently shows "Yes" & "No" as selection options, I want it the slicer to just show "YES" because no one will ever be selecting "NO".

 

 

Can anyone advise?

 

 

dillonfarrar Frequent Visitor
Frequent Visitor

Re: Removing Values from Slicers

This filters out data that I need in my report though. All I want is a way to filter out slicer options without actually removing the data. 

 

Just want to be able to hide a value in a slicer without actually filtering out the data. The Slicer currently shows "Yes" & "No" as selection options, I want it the slicer to just show "YES" because no one will ever be selecting "NO".

 

 

Can anyone advise?

 

dillonfarrar Frequent Visitor
Frequent Visitor

Re: Removing Values from Slicers

I have been describing this issue poorly, I really only need a visual level filter for a slicer... which does not seem to be possible. 

kulchandra Member
Member

Re: Removing Values from Slicers

@SivaMani @dillonfarrar @v-chuncz-msft

my data is in cloud and it changes time to time so i don't know what item will be there on daily basis. What i want is to simple select all except the Blank(). Please see the image attached.

 

Blank in Slicer.png

 

 

Any help is appriciated. Thank you guys

SivaMani Senior Member
Senior Member

Re: Removing Values from Slicers

@kulchandra,

 

Try the below approach

 

Blank.gif 

 

The reason for blank values can be found here

 

Thanks,

Siva

kulchandra Member
Member

Re: Removing Values from Slicers

@SivaMani Thank you for the reply. Will this work if my list grows from backend?

SivaMani Senior Member
Senior Member

Re: Removing Values from Slicers

@kulchandra,

Yes, It will work. It excludes only blank value.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors