Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I have a dashboard with financial data including actual costs versus budgeted costs. I would like to have a 'forecast' type column to project the full year forecast but I would like that to be an input field by the user that saves to an excel file. In other words the user is writing to an excel file through PowerBI.
Is this possible?
Hi @Anonymous
If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!
If not, please kindly elaborate more.
@Anonymous , refer to this. Done using google sheet and One drive excel
https://www.youtube.com/watch?v=LxuRzj0X348
You can look into the Alteryx Visualization for this
https://www.alteryx.com/partners/technology-partners/microsoft
https://powerbi.microsoft.com/en-us/blog/the-alteryx-starter-kit-for-microsoft/
Or you can create a Power App to Enter/Edit separately Forecast and then use this Power App visualization to have a Input form in Dashboard/Report.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |