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.
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.
Under Format ->Data colors of the bar chart , you can see "Advanced controls", open it and you will see conditional formatting windows.
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?
Hi @v-yuezhe-msft Lidia,
I have the latest verson. Download again and that option keeps not showing:
Do you have any idea why?
Thanks again 🙂
Hi @AnshulG ,
This is a very old thread and the capabilities of Power BI have moved on dramatically since this was posted.
If you're having trouble getting PBI to conditionally format how you want it to, I would strongly recommend you open a new topic in the Desktop forum and someone there will be able to help you very quickly.
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.
As my previous post, if you drag two columns, it is only possible to manually set the colors for each column. If you want to set colors for each column based on the condition as you describe, you can use table visual and configure conditional formatting.
In your second chart, please click Advanced controls to configure conditional formatting as below.
When you put all the values into chart which like the first chart, it is not possible to use Advanced controls option, you would need to manually set color for them.
Refer the following link, if that is not your requirement please elaborate your requirement.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!