Forum Discussion
Conditional Formatting of Bar Chart
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 :)
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- 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!
SoraiaT,
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.
Regards,
Lydia
Exactly, Even I have the same question
Hi Anonymous ,
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.
Pete
