Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
tksnota
Post Patron
Post Patron

Slicer based on Colour

Hi,

 

Is it possible to create a slicer using colour?

 

Thanks...tksnota...

 

tksnota_0-1733222915092.png

 

tksnota_1-1733222932295.png

 

1 ACCEPTED SOLUTION
v-xinc-msft
Community Support
Community Support

Hi @tksnota ,

Power BI currently does not support conditional formatting to slicers.

You could apply conditional formatting in tables and matrixes if you want to get the visual affects you provided.

1.png

2.png

Here is the code of ‘Color’ .

3.png4.png

We could use the same method to apply condition formatting in matrix.

5.png

Best regards,

Lucy Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-xinc-msft
Community Support
Community Support

Hi @tksnota ,

Power BI currently does not support conditional formatting to slicers.

You could apply conditional formatting in tables and matrixes if you want to get the visual affects you provided.

1.png

2.png

Here is the code of ‘Color’ .

3.png4.png

We could use the same method to apply condition formatting in matrix.

5.png

Best regards,

Lucy Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

danextian
Super User
Super User

hi @tksnota 

 

It is possible but the approach depends on whether your peercentages are from a  column or a measure. Either way, please post a workable sample data (not an image) which covers your use case - a cloud storage link to a sanitized copy of your pbix (confidential data removed) or an Excel file.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.