Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

date slicers default value

Hi,   I have date ranges from 2003-2020. When users first open the report the slicer should be 31/07/2010-31/07/2020 (as shows below), but all the previous dates are still available and they can ma...
Need Help
Fowmy's avatar
Fowmy
Super User
6 years ago

Anonymous 

Before you publish the PBIX file to the Power BI Service, Select the preferred date range, in your case July and publish.

If your dates are not adjusted by filters in the date column automatically based on any dynamic measure, this should work.
 

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

Thanks Fowmy 

 

When the report runs for next month, my end date will change to 31/08, will the slicer then automatically change the from and to date to 31/08/2015 - 31/08/2020?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    H Anonymous,

    I don't think it is possible it may slicer dynamic selection a default value.
    You can use bookmark to save current filter selection to reset/keep raw filter effect, but these selections not able to dynamic changes.
    Regards,

    Xiaoxin Sheng