Lumira Designer 2.0 how to change data source based on drop down value selected

Hi,

Lumira Designer 2.0 how to change data source based on drop down value selected and display data in a chart

I have requirement to show the data in a chart and text based on the drop down selection and drop down values are measure columns name like Daily, Weekly Monthly, Quarterly and Yearly ( please refer attached image)

DS Columns:

Region Country Daily Weekly Monthly Quarterly Yearly

Drop Down Menu Values:

Daily Weekly Monthly Quarterly Yearly'

main-data-source.png

To show in chart like ( please refer attached image)

data-display-chart.png

I thought of splitting the Data source into five data sources based on measure values

DS1

Region Country Daily

DS2

Region Country Weekly

DS3

Region Country Monthly

DS4

Region Country Monthly

DS5

Region Country Yearly

five-data-sources.png

But I'm not able to change the data source of chart using script based on drop down selection.

Can someone help ?

Thanks and Regards

Sahil