Stacked Column - Conditional Formatting

[JClark]

Hi, I have this visual in my dashboard where I would like the bars to represent the same colours as the cards (as shown). The 'Current Period' card has conditional formatting applied so when Current Period is less than 'Previous Period' it is red, if it is higher it is green. 'Previous Period' is always grey.

The problem I'm having is the stacked column seems to suit the purpose of showing current and previous period (seperate measures) but lacks conditional formatting of the Data Colours, whereas if I use a Clustered Column Chart I can only place a single measure.

The colours in the visual above were manually selected to show the outcome I'm looking for. Any advice would be great, thanks!

[JClark]

I still haven't been successful in finding a solution.

[mahoneypat]

Have you used the Columns area of the Format Options? You can enter the desired hexcode for your two measures.

Pat

[JClark]

Hi, that would be an option if I was looking to have static colours but they need to be conditional in line with the cards I'm using. I get the option to do so with one measure in the chart but not two: