Hi,
I am currently using a bar chart with 3 alternate measures and one dimension. In my chart subtitle I am currently using a variable $(vScaleMonthYear)& ' ' & $(vScaleformat) & $(vCurrencySwitch) which is toggled via filter selections MonthYear, Unit(m/k) & Currency Switch(EUR/LC)
Output is like Nov2019 mEUR.
New requirement is to hide the mEuro part while showing 2 measures.
I tried the below but doesn't seem to work.
=If(GetObjectMeasure()='MeasureA',$(vScaleMonthYear),
If(GetObjectMeasure()='MeasureB',$(vScaleMonthYear),
$(vScaleMonthYear)& ' ' & $(vScaleformat) & $(vCurrencySwitch)
)
)
Can anyone help in this?
