Forum Discussion
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 color of the cells in the body of the visualization depending on position as it is in excel report.
Thanks
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
2 Replies
- amitchandak
Super User
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 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.
