Forum Discussion
Helper ISlicers 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 UNSOLVED error :(
For example, I got report group by years, and last year, slicer values was (blank), 2016 and 2017.
I skip (blank) by uncheck it in report filter.
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!
3 Replies
v-ljerr-msftMicrosoft Employee
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
sekicHi, 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
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.