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.
In my case the (Blank) on a slicer only appears if there is more than one relationship to the dimension table. So it seems like a bug since I do not have any blanks within my data.
I was able to address this by simply changing the way the table interact with each other. In the relationships section in Desktop you need to select the relationship and the option on the bottomr right "Cross filter direction" needs to be set to "Both".
One more bit of advice...if you want to use Row Level Security you cannot check the box "Apply security filter in both directions". No matter the difference having the Both should address your issue though as long as you do it on the relationship to the table the filter belongs to.Thank you! You're the best this worked and I was literally losing it over this tiny lil error. My data did not have any blanks and I tried everything from removing blanks, replacing null, etc.
bmkHelper II
Thank you for this. My table does not have any blanks but on implementing this option addresses the problem. Would you now happen to know why this eliminates the blank?
