Dynamic measure column selection based on period selection in filter
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.
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.