Dynamic Subtitle

[soumroy7]

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?

[gourpros · Accepted solution]

Sorry you cannot use this in title or sub title, it's a chart function, check documentation.