Forum Discussion
I want my slicer to show only one button
Hello, below is a mock-up of what I'm dealing with. I would prefer to have a slicer that only shows the 'Yes' option (which I would rename as 'Available') so the slicer would only show one button ('Available') that I can toggle on and off. Is this possible? Is there a better way to do this?
1 Reply
Hi JessArvil450
a slicer always shows the contents of the source column, which is in your example Yes or No.
If you want to have "Available", you would need to replace Yes with Available in the source table, and remove the "No" entries.
Unfortunately, even then the slicer will give to options: Available and (blank) for the empty ones. In other words, as far as I can see there is no way to have a slicer with just one option.
If this is really what you need, I guess you would need to create a filter button using VBA.
