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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

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
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.