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
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

jude_expedio

 

As I tested in Power BI Desktop (2.39.4526.362 64-bit), it always adds "Blank" item Slicer. But setting Visual Level Filters to "Is Not Blank" only works for numeric field. But for text field, it still shows black values in visual even you set Visual Level Filters to "Is Not Blank". I suggest you remove the blank rows in Query Editor or create a calculated table with blank rows filtered.

 

Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    It shows the blank item even if there are no blank rows in the column. For instance I have a Sales Rep table. It has four rows, zero blanks in the "Name" column. If I use it as a slicer, there is a blank item.

    • laciodrom_80's avatar
      laciodrom_80
      Icon for Helper IV rankHelper IV
      9 years ago

      @KHorseman same problem: with previous version I was able to hidden blank value with filters workaround, but with september release I can't do it anymore :smileyfrustrated:

       

      Will be the problem resolved with october release?

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        laciodrom_80 The trick to start a visual in a table, apply filters and then change to a slicer was removed several releases ago. This "Blank" value topic alone is one of the main reasons I'm not happy it went away. You can vote this "hack" to be re-applied in the ideas section - here.