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! It's time to submit your entry. Live now!

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
337 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
321 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
326 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! It's time to submit your entry.

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

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