Forum Discussion

jude_expedio's avatar
jude_expedio
Frequent Visitor
9 years ago

Slicers - Blank Values when published - September 2016

The September release seems to be adding Blank Values into Slicers when published.  They are OK in the Desktop version, and the workaround of creating a Table first and seting Visual Level Filters to...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
Anonymous
Not applicable
9 years ago

Anonymous: Agreed. However, this will probably not be a prob in the coming weeks/months.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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.

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      9 years ago

      They need to add in the Paint Brush (Format) Menu of the Slicer => On/ Off Switch for Blanks

       

       

      Either there or in the Menu the 3 dots ... in the top right corner of the visualization itself!