The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
79 | |
73 | |
39 | |
30 | |
28 |
User | Count |
---|---|
107 | |
99 | |
55 | |
49 | |
46 |