cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
intrasight Member
Member

Re: SLICERS -> blank value

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?

intrasight Member
Member

Re: SLICERS -> blank value

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

campagnol54 Regular Visitor
Regular Visitor

Re: SLICERS -> blank value

raghun Frequent Visitor
Frequent Visitor

Re: SLICERS -> blank value

Is there a regression in the latest Power BI desktop for this option? It doesn't seem to be working. It worked fine in an earlier version

Super User
Super User

Re: SLICERS -> blank value

On the issue of what causes (Blank) values to appear in the first place, this definitely happens when a table on the many-side of a 1-to-many relationship contains values not present in the corresponding column of the table on the 1-side (with the slicer on a column from the table on the 1-side).

For example if my Sales table contains 2014, and is related to a Year table which doesn't contain 2014, then a (Blank) value is automatically inserted into the Year table (behind the scenes), to handle any values present in Sales but not present in Year.

Another way of thinking of it is the 'expanded' Sales table includes a Left Outer Join with the Year table, which results in (Blank) rows being generated where Sales contains a year that is not present in the Year table.

I'm not sure if this was causing the issue for the cases mentioned in this thread though...

Here's a dummy example showing one slicer with (Blank) from an 'incomplete' Year table, and one without (Blank) from a 'complete' Year table.

https://www.dropbox.com/s/9dnilwisu4wz9xh/Slicers%20blank%20example.pbix?dl=1

 

Capture.PNG





Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




TimothyS Visitor
Visitor

Re: SLICERS -> blank value

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 Regular Visitor
Regular Visitor

Re: SLICERS -> blank value

It does not! (Blank) still appears. Man Sad

vshruti06 Frequent Visitor
Frequent Visitor

Re: SLICERS -> blank value

This workaround (changing the visual and again change it to slicer) is not working in my case. The Blank vale is still coming.

dcresp Member
Member

Re: SLICERS -> blank value

I have tried this work around and can not get it to work. I am using thetable visual and in the Visual Filter and turning off do not display balnk. Can you please give me some more details about how you are doing this work around. Thank you.

footmarks Frequent Visitor
Frequent Visitor

Re: SLICERS -> blank value

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().