Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Using SelectedValue with Field Parameter (Prior Period Title Change)

Hi Everyone,   Down below I have my company's sample sales report.  I'm trying to achieve the following: -In the red square, when a value is selected, the title, instead of "Month-1, Month-2", rep...
Need Help
sundarausa99's avatar
sundarausa99
New Member
1 year ago
Use the below formula for getting dynamic chart title based on the field parameter selection.
 
Chart Title = IF(SELECTEDVALUE(Location_ZD[Location Parameter Order])=0,"Division",IF(SELECTEDVALUE(Location_ZD[Location Parameter Order])=1,"Region",IF(SELECTEDVALUE(Location_ZD[Location Parameter Order])=2,"Area",IF(SELECTEDVALUE(Location_ZD[Location Parameter Order])=3,"Market",IF(SELECTEDVALUE(Location_ZD[Location Parameter Order])=4,"Location")))))