Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |