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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
thmonte
Helper IV
Helper IV

Keeping date filter current in published report

Does anyone know if its possible thru settings somewhere to always have the date filter set to the current day?  Alot of the people I have shared the report with would like to just pull up the report and view todays current information with the option to go to other dates if needed.

5 REPLIES 5
ibarrau
Super User
Super User

Hi. You should add a relative filter using the date column. Then you can filter by "This Day".

 

Regards,


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

Happy to help!

LaDataWeb Blog

How would this help in my scenario?

 

I want to continue to be able to search over a range of dates but have that one filter always be defaulted to the current day upon opening.

 

If I was to make a "Today" dax expression Id lose the ability of selecting other specific days?

Add two visualizations of date filters. One with relative on "This Day"  and another with the way you want to filter. When you start the page you can select de erarser and remove the "This Day Filter" and start with the other.

 

Regards,


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

Happy to help!

LaDataWeb Blog

This is more of a work around than a solution IMO

Hi @thmonte,

 

That is the solution. Because if you'd like to choose other days, you have to stop "keeping". Right? But you don't need to remove the slicer or the filters. Just clear the effect of that filter. Maybe the Page Level Filter or Report Level Filter could be better.

Keeping_date_filter_current_in_published_report

 

 

Best Regards,
Dale

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

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors