Background color in matrix

[Transho]

Hi,

I am new to Power BI and seek help.

I have generated a transition matrix visualization with a connected bin field and several count columns as shown below.

I want to change the background color of the cells in the body of the visualization depending on position as it is in excel report.

Thanks

[Transho]

Thanks for the tip ... i did some research starting from the note about the switch function and created several color measures which are applied to each individual field ... and it worked.

[amitchandak · Accepted solution]

@Transho , You need kind of color measure

Switch(true(),

Max(Table[Bucket1]) = Max(Table[Bucket2]) , "Yellow"

Max(Table[Bucket1]) < Max(Table[Bucket2]), "Orange",

"Blue"

)

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