Forum Discussion

sekic's avatar
sekic
Icon for Helper I rankHelper I
8 years ago

Slicers with blanks, error

I got slicer on form which always add nonexistent blank value to check (blanks not exists in table). I can override it with page selection filter, select all but (blank) value, but this is still UNS...
General Comment
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi sekic,

This year 2018, we got new data, but I forget to check this selection to "add" 2018.

Report filter got uncheck (blank), check 2016, check 2017, UNCHECK 2018 ! 

Report is incorrect, because of "blank slicer" bug.

When it will be corrected, it's annoying to check every slider on every report whenever new search attribute is appear in any tables!

Instead of unchecking blank and checking the years manually, you should be able to use the Advanced Filtering Filter Type with "Show item when the value: is not blank" option to dynamically apply the report level filter in your scenario. :smileyhappy:

 

 

Regards

sekic's avatar
sekic
Icon for Helper I rankHelper I
8 years ago

Hi, yes, I find same workaround before, but my question is why this bug appears?

Sometime my customers said that they "fill" all needed attributes in tables and they're right, and ask from me to show where is that row with "blank" or null value?

  • sekic's avatar
    sekic
    Icon for Helper I rankHelper I
    8 years ago

    And sometime, blanks (null) value really exists in table. So, I will not accept "select all but blank" as solution, because it's allways risk to get incorect results from table.