How to create a dynamic drop down list ?

[Anonymous]

Hi guys,

Does anyone know how to create a dynamic drop down list ? 

I want to create a drop down list containing products. So basically i want the products to populate the dropdown list based on the year i filter the visuals with. I have a field called rolling12 which when set to true will display a 12 month period of results so i would like to use this field to create a measure that will solve my problem. 

Thanks 

[v-shex-msft]

HI @Anonymous ,

It is impossible to dynamic change slicer selections based on other filter/slicers, but you can write measure with dynamic result based on filters. Please provide some sample data and expected result to help use clarify your requirement.

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hi There,

Thanks for the reply. i managed to solve this issue by creating a measure to pull current year there after i set it to page filter. After that i set my relationships between tables both ways so now when i select a manager from the drop downlist it shows me all related products from the other drop downlists. 

Regards

Starlord