Forum Discussion
Removing Values from Slicers
Is there a way to hide the blank values but not filter out the data? For example: I have a column with binary values "Yes" or "No" but I want the slicer to just have the "yes" option showing...
I have been describing this issue poorly, I really only need a visual level filter for a slicer... which does not seem to be possible.
I know exactly what you are trying to do as I'm trying accomplish this myself. Right now I have buttons that that overlap one another and it works. One button sets the filter to 'Y' and the other sets the filter to "All Data". As one button is press, it hides itself and shows the other button. It works but it is not flawless as I would like it to be when using it online. Hope this helps.