Forum Discussion

BeeFArmY's avatar
BeeFArmY
New Member
2 years ago

Conditional Formatting

I need some help.

I'm using the string below to return positive numbers as green and negative numbers as red. When using a slicer the string below works perfectly but when selecting the value on a bar chart it doesn't?

 

Variance Status Colour =
SWITCH(
    TRUE(),
    [Variance Budget vs Actual]>0, "#63BE7B",
    [Variance Budget vs Actual]<=0, "#F8696B")

 

 

 

Thank you in advance.

3 Replies

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    BeeFArmY ,Select your bar chart visualization.
    In the Visualizations pane, click on the drop-down arrow next to the measure you want to format (e.g., [Variance Budget vs Actual]).
    Select Conditional formatting and then Background color or Data colors (depending on your preference and the type of chart).
    In the Conditional formatting window, choose Field value.
    In the Based on field dropdown, select the measure you created (Variance Status Colour).

    • BeeFArmY's avatar
      BeeFArmY
      New Member
      2 years ago

      bhanu_gautam thank you for responding so quickly.

       

      I believe I'm already doing what has been suggested. The conditional formatting is working but only when using a slicer. When I'm selecting a value in another visual which updates all of the other visuals, my conditional formatting doesn't work. For example, a minus should be red but shows as green.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, BeeFArmY 

    Thanks for bhanu_gautam reply. Have you solved the problem? Typically, setting the color format is just as bhanu_gautam describes, can you share pbix files without sensitive data for testing purposes (sharing by OneDrive or GoogleDrive).

    Best Regards,
    Yang
    Community Support Team