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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
joseph_Dev
Frequent Visitor

How can I enter temporary data into fields to forecast the graphs?

Hello, 

 

I have a Line Graph in PowerBI Desktop connected to a Dataverse Table, and I added this report to a PowerApp.

 

The Y-axis shows the field 'Net Yield %', and X-Axis shows the field Maturity Date (a date field in the dataverse table, so in PowerBI it also has Year, Quarter, Month, Day).

 

Is there a way to forecast future values? Can I enter dummy values that will change the graph accordingly, but without changing the actual Datasource table (the table in dataverse)?

 

Capture.PNG

 

Thank you in advance for any assistance provided. I really appreciate it.

 

Regards, 

1 REPLY 1
danextian
Super User
Super User

Hi @joseph_Dev ,

Try using what-if parameters to visualize variables.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-what-if 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.