Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

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

 

Need Help
Show and Tell

3 Replies

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Amy 

       

      Thanks for the reply. 

       

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

       

       

      • v-xicai's avatar
        v-xicai
        Icon for Community Support rankCommunity Support
        7 years ago

        Hi Anonymous ,

         

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

         

        Best Regards,

        Amy