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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
RMRaptor
Frequent Visitor

Color Code column values in matrix on filter selection

Hello All

 

How to write expression when value is selected from filter/slicer then apply specific color code to column   values only

 

for instance i'm selecting 

1)  State column value in slicer as Detroit,  color code all different places/locations to Red color in columns.

2)  State column value in slicer as Newjersy,  color code all different places/locations to Blue color in columns.

  

 

Matrix   :

Column : Location

Row : County

Measure: Population

 

Thanks

Rm

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@RMRaptor , if you are not using legend and you are able to see fx icon on color, you will be able to use a color measure and use it conditional formatting using field value option

 

color = Switch(selectedvalue(Table[State]) ,

"Detroit", "Red",

"Newjersy", "Blue",

"Green"

)

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@RMRaptor , if you are not using legend and you are able to see fx icon on color, you will be able to use a color measure and use it conditional formatting using field value option

 

color = Switch(selectedvalue(Table[State]) ,

"Detroit", "Red",

"Newjersy", "Blue",

"Green"

)

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.