Conditional formatting of measure color in DAX

[BobKoenen]

HI all,

I have 2 measures [sales untill today] and [forecast after today]. Which I combine in one measure to get the cumulative total of the actual sales and the remaining forecast         Sales+Remaining Forecast = ([sales until today] + [forecast after today]). 

Now I want to present this measure in a Bar chart with a month axis and I want the [sales unitil today] to be a diffrent color than [forecast after today]. With normal conditional formatting this is not possible because there is only one measure in the bar chart. 

Can you help me achieve this?

[dedelman_clng]

Hi @BobKoenen - have you tried a stacked column chart? You can put each measure in with a different assigned color, and then turn on the "Total Label" that will show the sum. You could also put the total sum in a tooltip so the user can see if when they hover over it.

Hope this helps

David