Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
jennifer_reis
New Member

Automatic date filter

‎11-07-2022 09:44 AM

Hi guys, I have a task where I need to filter automatic dates when I log into the report, so I need it to appear without having to click anything, is there any filter that does this or some calculation? I tried to use Relative Date, formulas in Dax and m language, but none worked.

I thank you for your help.

Message 1 of 3
332 Views
0
2 REPLIES 2
KNP
Super User
Super User

‎11-07-2022 10:03 AM

Hi @jennifer_reis, 

 

Would be useful to include some details about your model and some sample data.

If you add a column to your date table you can acheive this. 

This video may help.

https://www.youtube.com/watch?v=VaJ10ilXp6Y

 

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).		xOIEmaj

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
image		fabric-SUbadge
Proud to be a Super User!
Message 3 of 3
316 Views
0
ribisht17
Super User
Super User

‎11-07-2022 09:52 AM

@jennifer_reis 

 

Please check this blog Default Dynamic Date Filters In Power BI - Microsoft Power BI Community

 

Hope it helps!

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

Message 2 of 3
321 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.

View All