Color on 3 Last month

[Florent32]

Hello,

I have an Histogram with 3 value calculated.

Month -3 / Month -2 / Last month

I want to have a color different on each month.

I have try 

If (addMonth(today(), -1), '#505468',

     (If (addMonth(today(), -2), '#308523')

Or 

If (MasterDate.autoCalendar.month =-1, '#505468',

     (If (MasterDate.autoCalendar.month =-2, '#308523')

But it's does not works

Could you please help me?

[Saravanan_Desingh]

Have u tried, Multicolored under Colors?

[Florent32]

Hi,

Thanks for your reply.

I have to specified specific color code (client company color) so no possibility to use multicolor option...

Do you have an other idea? 🙂

[agigliotti]

Hi @Florent32 ,

Which are your actual bar chart measure and dimension ?

[Florent32]

Hello,

Chart representation below

I hope it's more clear,

Br,

Florent

[Florent32]

Dimension: Lot

Measures: Month -3 / Month -2 / Last month

[agigliotti · Accepted solution]

To achieve it, i suggest you to create a master measure for each one of the three measures, there you can also set a specific color.

[Florent32]

Thanks for the answer !

Have a good day!