IFs in dimensions

kruel830 — Mon, 10 Sep 2018 08:32:56 GMT

Hello,

I have a problem with if statements in dimensions. I would like to switch between actual numbers from the last 12 months and rolling 12 months figures. If statements work with KPIs and gauges, they don't work with charts.

Working graphs look like this:

But when I combine them to same line chart and use filter pane to change the dimension, the result is unwanted:

My dimension-if is: =if(vR12='1', CumulativeMonth, VoucherYearMonth) and if in measure is:

if(vR12='1', $(vSales), $(vSales12)). I assume the problem is CumulativeMonth-dimension, as it looks 24 months behind. But is there any workaround to solve this?

topic IFs in dimensions in App Development

IFs in dimensions