Hi, Does anyonw knows how to add conditional formating to bar chart? There are no options on the Format-> Colour or at the collum like on tables. Thanks!Soraia

SoraiaT,Under Format ->Data colors of the bar chart , you can see "Advanced controls", open it and you will see conditional formatting windows.Reference:https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/Regards,Lydia

Hi Anonymous Lidia, I have the latest verson. Download again and that option keeps not showing: Do you have any idea why? Thanks again :)

Hi Anonymous, The data are in a single row. what I want to see is the value on the column "A" and the value on the column "B". If the value on "B" is higher and lower than "A" i would like to see different colours. Is there a way to do this? Thanks!

In the Visualizations - Bar - Color select fx button to define a function for conditional formatting.

SoraiaT Hi Soraia, Refer the following link, if that is not your requirement please elaborate your requirement. https://community.powerbi.com/t5/Desktop/Conditional-Formatting-of-Bar-Chart/td-p/118370 https://community.powerbi.com/t5/Desktop/How-to-conditional-formatting-a-bar-chart-on-x-Axis/td-p/471370

Conditional Formatting of Bar Chart | Microsoft Fabric Community

16 Replies

Anonymous
Not applicable
7 years ago
SoraiaT,

Under Format ->Data colors of the bar chart , you can see "Advanced controls", open it and you will see conditional formatting windows.

Reference:
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2018-feature-summary/

Regards,
Lydia
- SoraiaT
  Helper I
  7 years ago
  Hi Anonymous Lidia,
  
  I have the latest verson. Download again and that option keeps not showing:
  
  Do you have any idea why?
  
  Thanks again :)
  - Anonymous
    Not applicable
    7 years ago
    SoraiaT,
    
    When you directly drag two fields to Values section of the column chart, please manually change color for each field.
    
    If you drag field to Axis and Values to column chart as below, you will have the advanced control option.
    
    Regards,
    Lydia
- Anonymous
  Not applicable
  6 years ago
  My question is that this won't work on a stacked bar chart.
  Your solution only works for single values in the column fields. How to format the colors individually on these?
TarasUtkin
New Member
3 years ago
In the Visualizations - Bar - Color select fx button to define a function for conditional formatting.
itsmebvk
Continued Contributor
7 years ago
SoraiaT

Hi Soraia,

Refer the following link, if that is not your requirement please elaborate your requirement.

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-of-Bar-Chart/td-p/118370

https://community.powerbi.com/t5/Desktop/How-to-conditional-formatting-a-bar-chart-on-x-Axis/td-p/471370
BA_Pete
Super User
7 years ago
Hi SoraiaT ,

Apologies for the necro, but I was trying to solve the same problem and came across this thread.

I solved this by moving the chart dimension from Legend into Axis. It appears that you can't conditionally format (nor sort sometimes) charts that use a legend.

I've attached examples of the difference in visual display just by moving the dimension. The chart using Axis is conditionally formatted based on rules.

Hope this helps you and/or anyone else that may stumble across this thread looking for answers.

Pete