Forum Discussion
Color Formatting (Font Color) not working on Calculation Group - Matrix
Hi TotalAnonymous ,
Based on the information, try to create the measure for vs P3M%, vs P6M%, vs YTD PY%.
vs P3M% =
CALCULATE(
[Sales Amount],
'Time Intelligence'[Time Calc] = "vs P3M%"
)vs P3M% Font color =
IF([vs P3M%] < 0, "red", IF([vs P3M%]> 0, "green", "black"))vs P6M% =
CALCULATE(
[Sales Amount],
'Time Intelligence'[Time Calc] = "vs P6M%"
)vs P6M% Font color =
IF([vs P6M%] = 0, "black", IF([vs P6M%] > 0, "green", "red"))
You can view the following links to learn more information.
Solved: Calculation Group Condiftional Formatting not work... - Microsoft Fabric Community
Solved: Conditional Formatting Matrix with Calculation Gro... - Microsoft Fabric Community
Solved: Conditional Formatting using Calculation Groups no... - Microsoft Fabric Community
Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous , thanks for your help! I'm sorry for late response...
Based on the screenshot, it seems that the negative value (-100%) is considered as green rather than red. However, please allow me to check the PBIX and get back to you. Thank you!