cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Change the color of the bars of a chart with respect to a target.,

Hello everyone!

Do you know in any way to be able to change the colors of the bars on my chart? Example:

CLCastroEn_0-1597435908855.png

data passing that target of 5% that are red and data that have a value less than 5% that have the green color. The truth has already given me a conditional format solution, but it didn't work out for me. I would appreciate if you have a tutorial or screenshoot to porder help me better!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: Change the color of the bars of a chart with respect to a target.,

@CLCastroEn ,

Conditional formatting is the right way to make it.
Check the screenshot below: go to formatting > data colors > default color Fx > format by rule > based on field ..
If it is percent try to add number in format 0.05 which will Power BI recognize as 5%.
Hope it will help.

 

cond format chart.PNG

View solution in original post

2 REPLIES 2
Helper III
Helper III

Re: Change the color of the bars of a chart relative to a target.,

CLCastroEn_0-1597436249719.png

the conditional format option does not appear to me when I right-click on values. (I have power bi in Spanish)

Highlighted
Solution Sage
Solution Sage

Re: Change the color of the bars of a chart with respect to a target.,

@CLCastroEn ,

Conditional formatting is the right way to make it.
Check the screenshot below: go to formatting > data colors > default color Fx > format by rule > based on field ..
If it is percent try to add number in format 0.05 which will Power BI recognize as 5%.
Hope it will help.

 

cond format chart.PNG

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors