Forum Discussion
JessArvil450
Apr 24, 2022Copper Contributor
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 ('A...
Martin_Weiss
Apr 25, 2022Bronze Contributor
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.