Dynamic Label

[rathnam_qv]

Hi All,

i have a bar chart which have measures as current year,Previous year and Previous to previous year.

and the labels for the above measures are CY, PY and PPY.

My Requirement is: want to display label as CY-2017, PY-2016 and PPY-2015 (should be dynamic)

can anyone help me.

Thanks,

Rathnam.

[sarvesh]

Hi.. Rathnam,

For this requirement, you add a drop down list of year by which user can chose year.

Regard's

Sravesh Srivastava

[Anonymous]

As far as I know out of the box Bar Chart measure labels cannot be defined by a dynamic expression, only by static text.

You can though have expression defined dynamic Titles, SubTitles and Footnotes.

[dsharmaqv]

try like this in label section

='CY - ' & '$(vSelected_Month)'

='PY - ' & '$(vSelected_Month)-1'

='PPY - ' & '$(vSelected_Month)-2'

define variable

vSelected_Month

=GetFieldSelections([Report Period])

Hope I understood it correctly

[rathnam_qv]

Hi Deepak,

I tried this but it is treating everything as text.

Thanks,

Rathnam.

[dsharmaqv]

can you please post your app

[rathnam_qv]

Hi Deepak,

i am not able to see attach option to attach my app.

Thanks,

Rathnam.

[rathnam_qv]

Hi Deepak,

If u can share your personal id, i will send my qvf.

Thanks.