Forum Discussion
SLICERS -> blank value
adamgor A work around I use quite often is to start with a visual that allows you to filter the value, select/exclude the blank, then change the visual to a slicer and the blank should be gone.
Advocate II was having the same issue. Here is the solution:
1: Go to Model (the last on the left side menu)
2: See if there is an unwanted relationship between data sets. (There must be one)
3: Delete the relationship and boom (now check)
Responsive ResidentThis pointed me in the right direction, but the solution was a little different. I checked my relationships and all of them were wanted. However, one of the tables had a value in the related field that was not present in the slicer table version of that field. This was enough to create the blank value.
In my case, this was actually a data error and fixing the field removed the blank. Other people may find the other value is correct, in which case the solution may be to add the extra values to the slicing table.
The general principle is the same though - the blank may be coming from a relationship one way or another.
Edit: Note this can also happen even when the unexpected value is not in a directly related table, but in one reachable through a chain of relations. The reachable table does not have to be in use on the report page.
I had the same problem, some rare values were not recorded in the dim table.
Thank you very much!!