Conditional Formatting for Line and Clustered Column Chart

[Anonymous]

Hello Power BI Users,

I am seeking help regarding Conditional Formatting for the Line and Clustered Column Chart attahced below. I need the columns to turn "Red" if it exceeds the budget (i.e. goes beyond the target line) and turn "Green" if it is at or under the weekly bedget (i.e. equal to or below target line).

Conditional formatting option is available in matrix and table. Is it also possible in charts and other visualizations? Kindly assist. Any inputs are much appreciated!

Thanks & Regards,

Anuj

Line & Column Chart - Turn "Red" if above target line - Conditional formatting

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

As the reply said above only when you have one column value then you can set conditional formatting.

You can create measure like

Measure = IF(AVERAGE('Table'[actual])>AVERAGE('Table'[budget]),1,0)

 Then create rule as below.

Result

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[Mariusz]

Hi @Anonymous 

You can click on the three dots next to Default Color as below, this will expand conditional formatting, however it will only show if you have only one value in the visual.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Anonymous]

Thank you! Enabling conditional formatting for any visual with that option is very useful.

[amitchandak]

@Anonymous 

Refer: https://chandoo.org/wp/conditionally-format-visuals-in-power-bi/

https://docs.microsoft.com/en-us/power-bi/visuals/service-tips-and-tricks-for-color-formatting