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

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
Highlighted
Helper II
Helper II

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

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors