Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi.. Rathnam,
For this requirement, you add a drop down list of year by which user can chose year.
Regard's
Sravesh Srivastava
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.
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
Hi Deepak,
I tried this but it is treating everything as text.
Thanks,
Rathnam.
can you please post your app
Hi Deepak,
i am not able to see attach option to attach my app.
Thanks,
Rathnam.
Hi Deepak,
If u can share your personal id, i will send my qvf.
Thanks.