Forum Discussion
Slicers - Blank Values when published - September 2016
Anonymous I get the blank item even in a table where it's just unique items for the slicer column. The Sales Rep table has two columns: Name and ID#. No blanks in either one. But when that's connected to another table and used as a slicer, (Blank) shows up again.
Anonymous: did you drag the column to the Report level filters and unchecked (Blank) ?
Anonymous yeah I can work around this but I have to do that with every slicer in every report. If there are no blank values in the column I'm using as a slicer there should be no blank value in the slicer, plain and simple. This is yet another blank bug in Power BI. They love to display blanks where they shouldn't. A new unnecessary and unwanted blank shows up with every monthly release.
Anonymous: Agreed. However, this will probably not be a prob in the coming weeks/months.
Also every time I try to filter out blank from something that doesn't actually have blanks, I get an error message that says there was a problem rendering the report. If I close the filter dialog it still filters correctly but that error message still pops up every time. Probably because I'm trying to filter out blanks that don't exist. So this thing is broken in two ways: it shouldn't show the blanks in the first place, and you get a meaningless error message when you try to remove the nonexistent blanks.