Hi,
I am having issues when trying to colour my bar chart and wondered if anyone can shed some light on this please?
Dimension: D_Date.autocalendar.month
Measure 1: =sum({<ddate_Y={'FY19'}>}Total_Val)
Measure 2: =sum({<ddate_Y={'FY20'}>}Total_Val)
I have then selected:
Colours > Custom > By Expression and added this logic:
if(ddate_Y='FY90',rgb(217,28,144),
if(ddate_Y='FY20',rgb(20,23,96)))
I have ticked 'The expression is a color code'
The chart then displays both measures as a Grey, any idea why this is please?
