Conditionnal formatting in a calculation group

Hi Kev59 ,
Based on your description, you want to apply a color to the _CurrentYear result based on the _Color variable. Unfortunately, DAX does not support conditional formatting directly in the metric itself. However, you can do so by using the conditional formatting options in Power BI.

ColorMeasure = 
VAR _CurrentYear =
    CALCULATE(
        SELECTEDMEASURE(),
        'Calendar Fiscal'[TFS Year] = YEAR(TODAY()),
        'Calendar Fiscal'[TFS Month Number] = 1
    )
VAR _LastYear =
    CALCULATE(
        SELECTEDMEASURE(),
        'Calendar Fiscal'[TFS Year] = YEAR(TODAY()) - 1,
        'Calendar Fiscal'[TFS Month Number] = 1
    )
VAR _Growth = DIVIDE(_CurrentYear - _LastYear, _LastYear)
RETURN
    IF(_Growth < 0, "#f71111", "#32a852")

Go to the Format pane and find the Data Color section.
Click the “fx” button next to the Color option.
Select Field Values and then select the ColorMeasure you created.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hi Anonymous 

So, if I well understood, I need to create a measure (not in group calculation) like your example above and like it to value filed of my matrix.

The problematic I will have is I have 13 items on my calculation group (1 per month and another for the YTD), so I will need to create 13 differents measures to color each values of each columns (13) of my matrix.... not really optimized 😉

right?

I going to try an keep you posted

Thanks for your help

Hi again,

Just tested.... error occured

For information my matrix looks like this:

The value field is based on a segment selection (Revenue or quantity), the rows field is also based on a segment selection.

To try to apply the color change, I have modified the "font color" in the "cell elements" section of the matrix...

What I'm doing wrong?

Hi Kev59 ,
Color might not be set inside a calculation group. You may need separate measures or a dynamic color measure using SELECTEDVALUE(), though it may not work per column.
I hope this helps.If so,consoder accepting it as solution.
Thank you.

Hi Kev59 ,
We haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

Hi Kev59 ,
We haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

Hi Kev59 ,

Can you please confirm whether you have resolved issue. If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. This will be helpful for other community members who have similar problems to solve it faster. 

Thank you.