Forum Discussion
Solved
SLICERS -> blank value
I have a question about using slicers in my report. I make slicer which show the two years, I have just two values in my year table. But I also see blank value , is it possible to hide this one ? ...
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.
rehanmaqbul
Advocate I
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)
This worked for me! This solution solves the problem at the root of the problem. Not just putting a bandaid to cover the problem without really solving the problem. Thank you rehanmaqbul!