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.
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!
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.. :(
No this work around does not work in the current version of Power BI.
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.
