The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
Solved! Go to 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
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