Dynamic Color Formatting

[ngct1112]

May I write ONE dax to do the Conditional Formatting applying to Columns A,B,C like that 

Color_DAX =
var _Darkgreen = " #34A853"
Return
if(Table[A] = 5, _Darkgreen)

Table

A	B	C
1	5	3
5	58	4
12	2	5
5	4	1

I may need a DAX rather than using Rules in Conditional Formatting.

Appreciated if any helps

[amitchandak]

@ngct1112 , better to create this on a measure like and use in conditional formatting with field value option

Color_DAX =
var _Darkgreen = " #34A853"
Return
Switch(true(),
sum(Table[A]) = 5, _Darkgreen
sum(Table[A]) = 3, "#FF0000"
"#00ff00"

)

refer for steps

https://www.youtube.com/watch?v=RqBb5eBf_I4

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[ngct1112]

@amitchandak , thanks but could I also apply this DAX to columns B & C as well without modifying?

What I am hoping is this DAX can cover all colums A,B,C rather than create 3 different DAX.

Great thanks.

[amitchandak · Accepted solution]

@ngct1112 , as long as conditional is needed column A or combination column A, b, and C you can use that for any values /columns.

If you need pass measure to condition check for calculation groups

[ngct1112]

@amitchandak , sorry, I may not explain my question very well and I will open an new topic to make it clear.

However, thanks for your answer and it helps a lot