Forum Discussion
Transho
3 years agoFrequent Visitor
Background color in matrix
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 colo...
- 3 years ago
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/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
Transho
3 years agoFrequent Visitor
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.