cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anuj_Bindagi
Regular Visitor

Conditional Formatting for Line and Clustered Column Chart

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 formattingLine & Column Chart - Turn "Red" if above target line - Conditional formatting

 
1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @Anuj_Bindagi ,

 

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.

1.PNG

Result

2.PNG

 

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.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

4 REPLIES 4
v-jayw-msft
Community Support
Community Support

Hi @Anuj_Bindagi ,

 

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.

1.PNG

Result

2.PNG

 

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.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

Mariusz
Community Champion
Community Champion

Hi @Anuj_Bindagi 

 

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.

 

image.png

Best Regards,
Mariusz

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

Please feel free to connect with me.
LinkedIn

 

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

amitchandak
Super User
Super User

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!