Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
I have a line chart showing values over time. By default, the chart always opens at the earliest date.
I’d like it to automatically focus around the current month (e.g., April 2025) when the page loads instead of starting from the beginning.
Is there a way to achieve this?
Default:
Desired:
Solved! Go to Solution.
Hi @PBIuserATK ,
Thanks for posting in Microsoft Community.
You can use a Relative Date filter to automatically focus the chart around the current date:
Add a slicer to your report using the date field.
Change the slicer type to "Relative Date."
This will dynamically adjust the chart to always focus around the current date when the report loads.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Regards,
Chaithra E.
Hi @PBIuserATK ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.
Hi @PBIuserATK ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.
Hi @PBIuserATK ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.
Hi @PBIuserATK ,
Thanks for posting in Microsoft Community.
You can use a Relative Date filter to automatically focus the chart around the current date:
Add a slicer to your report using the date field.
Change the slicer type to "Relative Date."
This will dynamically adjust the chart to always focus around the current date when the report loads.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Regards,
Chaithra E.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!