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
Hey all,
How can I display data in a forward looking manner.
For the estimates only. I have data out in to FY2026 for the estiamtes.
Thanks,
Dylan
Hello @hacked3
If my assumption is correct you are looking to see estimates for 2026 year also if that is correct than make sure you include the 2026 year also in your calendar table so that it can be displayed against the data.
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
Hello, I do not have any filters on yet. I have all the data displayed and PowerBI cut the data to October 2024. You are correct in the rest of your assumptions.
Hello,
I am working to pull estimates from a SQL Server DB. The estimates are populated well into the the next calendar year. Our Fiscal Year is 1 Quarter back from a typical calendar year, so we are just finishing Q2. I have data in our estimate table into Q1 of the next fiscal year that I would like to display. (The lower table.) I tried turning the Auto Date/Time off in the settings to remove the smart date table, and it did not work. I do not know what other options are as I am still learning the system.
Thanks,
Dylan
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
What is PRL? Why Auto Date/Time?
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!