Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
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.
Regards
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?
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.
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
189 | |
96 | |
67 | |
63 | |
53 |