Colour Issue On bar Graph

[vanderson009]

I have requirement as Forecast Vs Actual by Timeline.

For Timeline i have created Drill Down which contains Year,Quarter,Month,Week and my bar graph have two measures one is for Actual and other for Forecast. My requirement is when i drill from Year to Quarter (Similar for Quarter to Month to Week) then business want to change bar colour for both (Actual and Forecast). 

Thanks and Regards,

Villyee.

[rangam_s]

We can keep bar color based on dimension (only when we have single measure), but I don't know think there is an option to change the bar color based on drill down. However, you can use custom color as 'Multicolored' but the color of actual and forecast will remain same over the drill down.

[sumanta12]

Hi Villyee,

First you have to add both the measures(Actual & Forecast) in Master items(Measures) and as per requirement set measure color for both measures.

Then in Bar chart in color&legend section select Multicolor and use Measure as  library colors .

[Neymar_Jr]

Hi vanderson009,

Please see if the attached helps you.

Thanks,

RT