Forum Discussion
Solved
Button Slicer - State disabled
Hi folks, as of my understanding, the button slicer used with month names has the option of greying out buttons, that don't appear yet (e.g. in my example the months october to december for the year...
For fellow travellers out there:
Greyed out categories are now possible in the button slicer since the october Power BI update (Power BI October 2025 Feature Summary | Microsoft Power BI-Blog | Microsoft Power BI).
Therefore I have a solution since today!
Thanks v-nmadadi-msft srlabhe and MasonMA for the contributions!
Hi,
In my understanding Slicer is simply showing values based on what’s in the field you drop in. I've not seen a property for 'disable if no data' like you might see in some custom visuals.
In your situation, i'd just use a Measure to restrict what's to be shown in the slicer based on if there's data in your fact table, set to 1 on visual-level filter for this Slicer.
INT(
NOT(
ISEMPTY('Table'))
)