Reply
Regular Visitor
Posts: 20
Registered: ‎01-24-2017

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.

Super User
Posts: 10,775
Registered: ‎07-11-2015

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
Posts: 2,164
Registered: ‎07-22-2015

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)


Highlighted
Super User
Posts: 1,713
Registered: ‎05-10-2016

Re: color bar chart based on budget

[ Edited ]

@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!