Bar Chart Colours

[thomas_2583]

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?

[StarinieriG · Accepted solution]

Hi,

try to create two master measures and then select the colors