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

View all the Fabric Data Days sessions on demand. View schedule

Reply
hacked3
New Member

PRL Auto Date/Time

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.

 

Example.PNG

Thanks,

Dylan

4 REPLIES 4
dharmendars007
Super User
Super User

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

LinkedIN 

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. 

hacked3
New Member

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

lbendlin
Super User
Super User

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?

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