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.

[Anil_Babu_Samineni]

Check This

[Prasanna_Yengunde]

Thanks Anil for your quick response, However this looks quite bigger change as i needs changing back end data model.

I have already developed few charts and it would be very helpful if I can achieve it using Set Analysis or any expressions. I worked on tableau before and there you can simply use parameters and use If condition to dynamically change measures.

Any help to achieve this in other way?

[lorenzoconforti]

can you post your application and an excel view of what you are trying to achieve?

It's easier to help you if you give access to your dashboard