Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Have u tried, Multicolored under Colors?
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? 🙂
Hi @Florent32 ,
Which are your actual bar chart measure and dimension ?
Hello,
Chart representation below
I hope it's more clear,
Br,
Florent
Dimension: Lot
Measures: Month -3 / Month -2 / Last month
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.
Thanks for the answer !
Have a good day!