Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Date Range Selection

Hello Experts,

 

I have date picker in my PowerBI Dashboards . My Requirement is to have date auto selectedwith Month start date as from date and month end date as Todate.

 

Please help with your suggestions

Need Help

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    Anonymous

     

    Currently, we can't put expression into the slicer to have the end date to be Today(). However, you can create a calendar table that dates are always up to today.

     

    Table = CALENDAR("2016/1/1",TODAY())

    Then put the date column in above calculated table into a slicer for selection.

     

     

    Regards,