Format Columns in Matrix based on color

[Anonymous]

Hi All, In the below matrix Would like to show 01.Actual (value1,valu2) in orange , 02.Budget (Value1,Value2) in green color, 03.Forecast(Value1,Value2) in Blue color, like how i mentioned below Please help. Thanks.

[v-shex-msft]

HI @Anonymous,

In fact, the conditional formatting feature allows you to use other field values for formatting.

For your requirement, you can write measure expressions to extract the current category value for color formatting.

Using the SELECTEDVALUE function in DAX - SQLBI

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Anonymous , Create a color measure like the one given below and use that in matrix in conditional formatting -> Advance option -> Field Value

Switch( Max(Table[Type]),
"01.Actual" , "orange",
"02.Budget" , "green",
"03.Forecast" , "blue",
"White"
)

You can refer to my video for steps: https://www.youtube.com/watch?v=RqBb5eBf_I4

or refer

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