Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

date to default today date when user opens report

hi

 

i have the scenrio where my users should have the defualt date slicer with today as option but there should also have the from date and to date as between time slicer as well but when they open the report by defualt from and to date should be today . I think this is not possible currently . For that i had created the measure for "most recent" "Not latest"  as two options as slicer . when i select the latest from and to date is not chaging to today where my users are getting confused because of this . can anyone guide me how i can i set the from and to date slicer ? Here is below example even if i clicked on most recent date which is"03/18/2019" the "to date " and "from date " is being static there .can anyone guide me here

 

latestdate.png

 

1 REPLY 1
v-lili6-msft
Community Support
Community Support

hi, @Anonymous 

Now when you log out of Power BI and come back to a report, the same items will be selected as when you left.

So for your requirement, it couldn't achieve that set a default value(or maxdate) for a slicer.

https://community.powerbi.com/t5/Desktop/Date-Dropdown-Filter-Auto-Update/m-p/628488#M300296

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7162004-default-selected-slicer-or-tile-by-value-configura

And even though you created the measure column for "most recent" "Not latest"  as two options as slicer . when you select the latest, the date slicer will not be changed dynamically.

For you requirement, I suggest you use relative date slicer in power bi.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

 

Best Regards,

Lin

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.