Color a combo chart based on measure name and one dimension

[etiennesan]

Hello everyone, 

I am trying to do the following: I have a combo chart showing two bar measures and two line ones. I have the daily sales of a reference month (bar for daily, line for accumulation), and I am using this to apply to the current month sales and try to predict where it will end (this time one bar and one line too, but up to the current day it is actual results and then it is forecast).

I want the following:

• same color for the reference line and bar, and same color for the current month line and bar
• change a bit the color of the current month line and bar, to show the difference between actual and forecast

Is there a way to do this in QS? I tried using the color by formula functionality, but cannot get it to work.

Thank you very much!

[Dalton_Ruer · Accepted solution]

I was able to accomplish what you are looking for by using Master Measures and simply defining the color for each. 

[etiennesan]

Thank you for the tip! Indeed works for setting the two bar and line couples in the same color.

What about changing the color of the master measure based on the current dimension? (I would like a lighter color when I go above the current date_no, that I have as a variable) I tried using segment colors but it doesn't seem to be working.

Etienne

[etiennesan]

Could solve the issue by splitting the master measure in two, and giving a different color to each part. Thank you!