topic Re: Color Formatting (Font Color) not working on Calculation Group - Matrix in DAX Commands and Tips

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

TotalAnonymous — Mon, 10 Feb 2025 07:52:19 GMT

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

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

FarhanJeelani — Mon, 10 Feb 2025 11:56:37 GMT

Hi TotalAnonymous ,

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

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

TotalAnonymous — Tue, 11 Feb 2025 01:03:01 GMT

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

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

TotalAnonymous — Tue, 11 Feb 2025 02:14:22 GMT

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

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

Anonymous — Tue, 18 Feb 2025 08:45:31 GMT

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.

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

TotalAnonymous — Tue, 11 Mar 2025 01:38:24 GMT

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!