Hi
I am trying to define expression to control color of my bar graph, by dimension using a below expression but it's giving me error, not sure what's wrong.
if(ACCOUNT_TYPE <> ' ',if(getselectedcount([REPORT])=0,ACCOUNT_TYPE,{$<[ACCOUNT_TYPE]+={A,L,OBS}>}),0)I want it to be able to pass the A,L,OBS values always, when there's a selection of report. otherwise the default graphs are turning gray. (LA & LB are the default bars that i always want to display regardless of the selection. (and graphs should display 3 different colors by the amount type
Expression for the amount measure is as below:
if(ACCOUNT_TYPE <> ' ' ,if(getselectedcount([REPORT])=0,Sum(AMOUNT)/1000000000,Sum({$<[REPORT_NAME]+={'LA','LB'}>}[AMOUNT]/1000000000)),0)
