Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.


A way to have a slicer with icons (green tick / red X)?

Hi, is there a way to include a conditional formatting slicer where I would simply have users to choose between Live (green tick) / Not Available (red X) attributes?


Thanks, Atanas


Hi t-atgeor,

I don’t think Conditional formatting could work with Slicer Visual in Power BI.

The font color could be customized under Slicer Visual, which applies to the whole Visual, but can’t be set with special item.

We may take a try to build an additional slicer to filter the available or not available items, and put the selected item into another slicer, like this:


Regarding how to identify the available status, we could create a new column to mark it and then update data at the data source side.





There is a third party slicer called the chicklet slicer that will do this.

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors