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,


Just following up to see if the suggested approach helped with applying conditional formatting specifically red and green icons to your visual calculation for Variance. Since you're working with a visual calculation rather than a DAX measure, we understand the setup might be a bit complex.

 

If you're still encountering issues or need further guidance, feel free to reach out. We’re happy to help!

 

Warm regards,
Prasanna Kumar