Forum Discussion
SLICERS -> blank value
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.
I have data that has 0 blank values, yet I still see (Blank) on many of my slicers
Any way to fix this?
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 Thanks! I was able to apply a blanket page wide filter such as this, and it has fixed my issue!
Unfortunately I use the same workaround.....
They just need to add the option to be able to Turn Blank Values Off / On in the Slicer Options and I really hope they do this!
Hi Anonymous,
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.. :(
Thanks for the idea/hack Seth. So this is just a bug?
tenaciousdata (Shrugs) - I wouldn't say bug since it's never existed, I'd say it should be a feature request to include the option in the slicer.
Gotcha. Just don't understand the reason for the blanks in the first place....probably something logical....paging @mspowerbi
On a side note, with you leonardmurphy Mykhael & myself I believe the Wisconsin mafia can take over this community :-)
Just kidding Sandy
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
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
This workaround (changing the visual and again change it to slicer) is not working in my case. The Blank vale is still coming.
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.
I found a quick trick. If applicable, add the field showing the blanks int he Page level filters section; on the filter check Select All then uncheck (Blank).
I hope this helps! :)
If we add the page level filter then it would be visible to end user after deploying it on powerbi.com. So I don't think this is a good idea.
hi,
is it the same now or can i hide the empty checkbox from slicer without removing assosciated data?
pls help
Anonymous 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.
