Forum Discussion
Table visualisation, color lines
PhilCh , I am not sure about line, but you should be able color background using color measure and conditional background formatting
example
Measure =
Switch(true(),
max(Table[Column]) = "R1" , "Red" ,
max(Table[Column]) = "R2" , "Green" ,
max(Table[Column]) = "R3" , "Pink "
)
use in conditional formatting using field value option
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
Hello amitchandak ,
Thank you for trying to help me.
First when I go to conditional background formatting using field value I have the windows below, not a field for DAX.
Second, I m not sure I understund your code as I told you I don't know the categories and how many they are, it changes at every refhresh of the database.
I can only specify I want a different color for every distinct category