SLICERS -> blank value

[GGR]

I have a question about using slicers in my report.

I make slicer which show the two years, I have just two values in my year table.

But I also see blank value , is it possible to hide this one ?  

Thanks for your time

GGR

[Anonymous]

Hi,

I went to investigate and found that the company that developed this (in many ways rather excellent) custom visual still has "ragged hierarchy" (which means that "empties" are not displaid) on their development list. I hope they get to it soon, or that MS makes this visual standard with a few enhancements.

[bourquejeff]

Another great way to deal with this is using the custom visual "Chicklet Slicers" by Microsoft. I had this slicer issue - mine included not only blanks, but also other records represented in the slicer that had a null or zero value for the measure I was hoping to filter them by. Using the chicklet slicer, the report not only looks better, but easily filtered out the records in the slicer that did not have a value by dragging the measure I was using into the data field of the slicer visual. 

[kleighton]

Thank you @bourquejeff !!

just what i needed!

[theBIbutler]

Thanks you @bourquejeff was struggling to find a way around that one that didn't involve a Page Filter......

[footmarks]

I was experiencing this same issue with a very simple table (Hour).  The data source did not have any null values, nor did the table that had a relationship with the Hour table, but the Blank() would still show in the slicer.

The fix to this issue for my situation was to check the "Assume Referential Integrity" box from within the relationship between the two tables.  This will make the relationship an "inner join" eliminating the Blank().

[MAAbdullah_47]

Referential Integrity is not working in Power bi.

[intrasight]

I also have "(Blank)" showing up. But there are no records with blank so the "filter" workaround isn't working.  So I'll ask again - why is there a "(Blank)" in the slicer?

[TimothyS]

Even though "Blank" is not showing up on other visualizations, uncheck "Select All" and select only the items you want. This will fix your problem. 

[EZgrafton]

It does not! (Blank) still appears. 

[campagnol54]

It is an ennoying bug. Please vote here :

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9708828-bug-blank-appears-for-sli...

[intrasight]

I used an "is not blank" filter and now "(Blank)" is banished.

[ashishrj]

@GGR You can filter data while importing using query to exclude blank values. But you won't be able to see associated records with blank value. OR you can rename the blank values to some meaningful name by creating a calculated column. Hope this helps!

[dineshkumar_vrv]

Hi, I want to replace my blanks into word "Blanks" so that I can show them in the slicer as blanks itself as one line item, is it possible ??

I have list of word in the 1st column 

column1

Apple

Bag

Car

             <- Blank 

Echo 

Expecting Output:

column 

Apple 

Bag 

Car 

(Blank)

Echo 

Thank you in advance 

[asreenu]

hmm..I wonder what the PowerBI team is doing if they are not even looking at the feedback.  This is a very visible and simple problem for two years and still not fixed.  How can we trust any MS products?

[adamgor]

I have data that has 0 blank values, yet I still see (Blank) on many of my slicers

Any way to fix this?

[Seth_C_Bauer · Accepted solution]

@adamgor A work around I use quite often is to start with a visual that allows you to filter the value, select/exclude the blank, then change the visual to a slicer and the blank should be gone.

[Anonymous]

@Seth_C_Bauer  I have created a Table with all the slicer values and have filtered out the Blank value and converted that to Slicer. However, the problem wasn't fixed and I could see the Blank value. Could you help me with this issue. Thank you. 

[Anonymous]

hi,

 is it the same now or can i hide the empty checkbox from slicer without removing assosciated data?

pls help

[Anonymous]

Hi @Seth_C_Bauer,

I tried your workaround but  it doesn't work for me. I changed the visual to pie chart, went to filters and ticked all the variables besides blank. Then I got back to slice but blank still appear.. 😞

[dcresp]

No this work around does not work in the current version of Power BI. 

[Anonymous]

thx @dcresp