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

color bar chart based on budget

I am new to Power BI.  I am a report writer, but not a strong developer.  I am hoping to find a way to color a bar in a bar chart based on performance vs. a budget.  So if a person is 95% of budget their bar = RED if a person is 96-99.99% YELLOW, and if 100% or more the bar is colored GREEN.  I would also like to display the budget bar as BLUE.  I will need to do this for both MTD and YTD and will have the data change daily.

 

I am also hoping to make this a Area > District > Region drill down chart which also seems to be a challenge in Power BI (for me anyway).

 

Any help is greatly appreciated.

3 REPLIES 3
Super User
Super User

Re: color bar chart based on budget

There is no conditional formatting for bar and column charts yet. Only for Tables and Matrices currently.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Super User
Super User

Re: color bar chart based on budget

you should vote this idea https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9588453-conditional-formatting-th...

 

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

www.perytus.com
(MVP Data Platform)


Super User
Super User

Re: color bar chart based on budget

@andymc123

 

Hi, a partial solution is that you can color your bar chart or column chart in 3 ranges.

 

Step 1: Add your measure in Color Saturation Section 

 

Color Saturation.png

 

2. Step 2 Go to Format --Section Data Colors - Enable Diverging 

 

And Select Minimum, Center, Maximum

 

divergente.png

 

 

 

 




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!