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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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...

 

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...

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors