Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Apply conditional formatting to a visual calculation

Is it possible to apply conditional formatting, specifically the red and green icons, to a visual calculation. I am unable to replace the visual calculation with a DAX measure due to the complicated ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community.

     

    Please try creating a single visual calculation measure for Variance and apply conditional formatting using the following DAX query:

     

    Color =
    VAR Variance = [Actual Cost] - [Standard Cost]
    RETURN
    IF (Variance >= 0, "Green", "Red")

     

    If the issue continues, feel free to contact us. We are here to assist you.

     

    Best regards,
    Prasanna Kumar

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anonymous,

 

Thank you for reaching out to the Microsoft Fabric Forum Community.

 

Please try creating a single visual calculation measure for Variance and apply conditional formatting using the following DAX query:

 

Color =
VAR Variance = [Actual Cost] - [Standard Cost]
RETURN
IF (Variance >= 0, "Green", "Red")

 

If the issue continues, feel free to contact us. We are here to assist you.

 

Best regards,
Prasanna Kumar