Dynamic measure column selection based on Period selection in Filter

[Prasanna_Yengunde]

I have a data where Period calculations such as MTD, QTD, YTD are mentioned in separate columns in back end data. I want to add a filter in front end as MTD, QTD, YTD and then want all charts in sheet to be populated as per flter selection and take values from correct columns. For example - If I select QTD in filter, all charts should refer to QTD column in the back end and return the correct values for selected period.

[lironbaram]

hi 

assuming you create a period field with the values MTD,QTD,YTD

than you can set this field to one selected value 

than in your measures use this expression for example 

=$(='sum(' & period & ')')

this assumes that in your data you have columns with the names MTD,YTD,QTD