How do you create a dropdown lists showing current year and current month as default ?

[Anonymous]

Hi Guys,

I want to create a two dropdown lists in power bi that will show my current year and current month.

i have the Year and Month fields and i also have the the Flags. 

CurrentYear_Flag and CurrentMonth_Flag. 

Thanks

[v-xicai]

Hi @Anonymous ,

Put your Year and Month field on slicer visual , and there is a dropdown arrow on the upper right corner of the visual, you can choose "Dropdown"

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi Amy 

Thanks for the reply. 

However i want the dropdown list to default to my current year. 

[v-xicai]

Hi @Anonymous ,

You can create Year column use YEAR(TODAY()) , and then put it on slicer.

Best Regards,

Amy