Forum Discussion
Color Formatting (Font Color) not working on Calculation Group - Matrix
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
5 Replies
Hi FarhanJeelani , thanks for your help! Please allow me to check and get back to you ASAP
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!
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
