Forum Discussion
Conditional formatting in a clustered column chart
Hi everyone
I have a clustered column chart with many columns. What i want to do use conditional formatting on the chart so if one of the bars has a value higher than a certain value it will be a certain color. When i look online for a solution it says i should look under data colors and find diverging. I cant find that. Does anyone know how to solve that problem?
Sincerly
Christian
Sorry for misleading you, I did not understood the question at first.
You can do that, and here is how to do it step by step :
1 - Add the value you want to use as a color filter in the Color Saturation field
2 - Go to the Data Colors section in the Format area, it looks like that :
3 - Input the value as it follow :
Here I've put 999 999 as minima so that everything below is black and not half yellow half black
- Quentin
15 Replies
Hello Et1w
You can't find it because diverging doesn't exist for clustered column chart. Try other visuals or try this tutorial :
https://docs.microsoft.com/en-gb/power-bi/service-tips-and-tricks-for-color-formatting
- Quentin
Thank you for your answer. Do you know of another way to solve the problem?
Can you post here a screenshot of what you have at the moment ? It will help me trying to answer your question, I'm thinking about something but not sure about what you have
I may have mislead you
- Quentin
