Advance Controls for Stacked Column Chart Data Colors

[Justair07]

Is there no way to apply conditional formatting for stacked column data colors? I dont see the Advance controls on my stacked column data colors property like I do for the regular cluster column chart.

Regular Cluster Column Chart:

Stacked Column Chart:

[vanessafvg]

@Justair07 do you have something in the legend area of the stacked column chart, if so that woudl be the reason why

[Justair07]

@vanessafvg is this what you mean? If so, no I don't 😞

[vanessafvg]

@Justair07its because you have multiple measures.  put only one in and you will see it comes back

[Justair07]

@vanessafvg So it sounds like the answer is "Yes you can but only if you have one measure". I guess I have to ask why use a stacked instead of a cluster if you are only going to have one measure? I was hoping that I could apply conditional formatting to multiple measures.

[vanessafvg · Accepted solution]

@Justair07  putting conditional formatting on 3 different measures could be quite difficult to process to be honest, but if you change the way you modelling the data you might be able to achieve something close to what you want.

[Justair07]

@vanessafvg I agree. I actually just made a few more DAX measures to represent the different colors I wanted to display based on the same rules I would have used in my conditional formating and it works great. Thank you.