Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have 2 measures in a bar chart to show a 2018 VS 2019 chart. I want to set 2018 to be one color and 2019 to be a different color.
I have tried:
=if(sum({$<[Move Date]={">=01/01/2018 and <=08/31/2018"}>}[Profit]),
rgb(35,175,130),
if(sum({$<[Move Date]={">=01/01/2019 and <=08/31/2019"}>}[Profit]), rgb(230,0,80)
)
)
but i get a chart that is all green.
I have tried:
=if([Move Date.autoCalendar.Date]>='01/01/2019', rgb(35,175,130), if([Move Date.autoCalendar.Date]<='12/31/2018', rgb(230,0,80)))
and the whole chart is grey.
Please let me know how i can get each year to show as a different color.
i guess you should use a combo chart with 2 measures to achieve it.