Hi guys,
I have created a bar chart, has multiple values. all i want is have another color for the values less than 5000, by individual categories.
PROBLEM: I know changing the 'background color' in the expression will change the color of the bars, but my expression is a variable, and when I put in the variable, it is not working.
i want the bars to differ in color by their values and category.
My variable comes from the "Actual" button selection. the formula being passed is:
=(sum(
(if(Period='MTD' and v_CurrencyButton=0,[MTD Actuals Global Currency],
if(Period='MTD' and v_CurrencyButton=1,[MTD Actuals Constant Currency],
if(Period='QTD' and v_CurrencyButton=0, [QTD Actuals Global Currency],
if(Period='QTD' and v_CurrencyButton=1,[QTD Actuals Constant Currency],
if(Period='YTD' and v_CurrencyButton=0,[YTD Actuals Global Currency],
[YTD Actuals Constant Currency]))))))))
what am i doing wrong?
thanks!
