Color Formatting (Font Color) not working on Calculation Group - Matrix

[TotalAnonymous]

Dear Community, 

I hope you're doing well. 

I'm facing an issue regarding applying conditional formatting (Font Color) into Calculation Group (served as column) in Matrix. Please kindly find the link of PBIX below. The data here is a sample. 

As you can see in the image below, the idea is to applying conditional formatting to some of Calculation Item (vs PY%, vs vs P3M%)

Afterward, I'm applying this measure to Conditional Formatting - Font Color menu as follows

The result is as follows, the color formatting is still not applied. 

Would you mind to help me how to apply the conditional formatting in this matrix? Thank you in advance

Link: https://drive.google.com/file/d/1WwSxCUlupZROfHZr-r2XJyWncz7Ao7Im/view?usp=sharing

[Anonymous]

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.

[TotalAnonymous]

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!

[TotalAnonymous]

Hi @FarhanJeelani , Thanks for your support in advance. It means a lot for me.
I have checked the PBIX, it seems that the measure that has been applied by Color formatting is "P3M". While the measures that I need to color format are "vs P3M%", "vs P6M%", "vs YTD PY%". It seems that in the PBIX file you've attached, those measures are not affected by color formatting. Thank you

[FarhanJeelani]

Hi @TotalAnonymous ,

Please use the attached PBIX. I did the change on DAX.

[TotalAnonymous]

Hi @FarhanJeelani , thanks for your help! Please allow me to check and get back to you ASAP