Forum Discussion
Conditional formatting not available on column chart
I do not have the conditional formatting option available for a clustered column chart. The chart has a date on the x-axis and number on the y-axis. I have set the default summarization to "Don't summarize" but for the value, it is set to "Sum" because not summarizing is not available. All tables are in storage mode "Import".
My final goal is for bars that satisfy a condition to be red and the rest green.
Any help is greatly appreciated, thanks.
Hi bclrk ,
Based on my research, Conditional formatting is not available in multi-legands (Y-axis) bar chart, if you have only x-axis, you will find this option in the data color label.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
9 Replies
Hi bclrk ,
Based on my research, Conditional formatting is not available in multi-legands (Y-axis) bar chart, if you have only x-axis, you will find this option in the data color label.
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.I am on February 2020 version and even only with X-axis the conditional formating is not accessible. And on the top of it removing the conditional formation on Bar Charts as a whole is not acceptable. This is a standard functionality of every BI product. What to replay to our customers "Sorry but Microsoft decide to remove the conditional formation without any reason". Do you understand how rediculous it sound if you are a customer and the vendor told you that such a basic feature is depricated?
I agree. This is basic functionality that our customers expect. Its absence is not only confusing, but frustrating.
Version: 2.73.5586.661 64-bit (September, 2019)
