Color Expression on stacked bar chart based on measure
Hi, I have a stacked bar chart that has one dimension and two measures. the dimension is 'Customer' and the measures are 'SuccessCDR' and 'FailCDR', on the stacked bar chart, I want the 'SuccessCDR' to show as lightgreen() instead of blue and 'FailCDR' to show as lightred() instead of red.
Every example i have found is checking a value like
Simply change the first and second color in the color tab of the chart properties or set the background color of the expressions by clicking on the + sign in front of the expression and use LightGreen() or LightRed() as expression for the background color.