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.
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.