topic Re: Conditional Formatting in DAX Commands and Tips

Conditional Formatting

BeeFArmY — Fri, 26 Jul 2024 07:52:13 GMT

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.

Re: Conditional Formatting

bhanu_gautam — Fri, 26 Jul 2024 08:31:02 GMT

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).

Re: Conditional Formatting

BeeFArmY — Fri, 26 Jul 2024 08:43:45 GMT

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.

Re: Conditional Formatting

Anonymous — Mon, 29 Jul 2024 02:04:00 GMT

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