Forum Discussion
Conditional formatting with multiple column/bar values
Hi Anonymous ,
This has to do with the setup of the chart when you are using a legend or more than one measure or calculation to make the split between several items the condittional formatting is turn off since each of the categories will have it's own colour.
What exactly is your need, do you want to have a single colour for each of your measures? if that is the case you just need to change each one individually on the data colours:
Or do you want to set the limits for each of the measures you have and get different colours depending on the result of the measures?
I have multiple measures and for each of them specific limits and warnings which I have calculated indivuadully. As you said, I need to apply conditional formatting for each measure with a specific rule depending of their calculated limits, and plot them in the same visual that has the custom filter i made, which allows me represent only one of the multimple measures.
I don't know if I have explained myself properly, my english is not as good as it should.
Thank you.
Hi Anonymous ,
Not really sure if this is what you need but using a disconnected table with the measure and making them part of the x-axis you are abble to have a single measure to have the condittional formatting working check the image below if this appearance looks good to you or what is missing.
Again if you can share a mockup of your data would be easier to achieve an answer.
Hi Miguel, I was reading the question and looking at your solution and this is exactly what I'm trying to do. I have a clustered bar and line chart with Actuals and Forecast as the bars. I would like to conditionally format the Actuals bar so that is a different color if we're still within the current month. Looks like your solution would work. Could you provide a few more details on making the measures part of the x-axis? Could you provide a sample file? Thanks!
