Forum Discussion
Format Columns in Matrix based on color
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.
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
2 Replies
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
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