Forum Discussion
How to write to power BI DASHBOARD
Is it possible for enter data in power bi dashboard table so the value in another column can change
In the below example is it possible for the sales person to enter 'New price' in a power BI dashboard table so the 'New price index' field updates automatically
Sales are calculated by qty * price
So I want the New price index to update when the 'New price' is entered by the sales person
| Article Number | Article Description | Competitor Price | Qty | Competitor Sales | xyx Price | xyz Annual Sales | Price Index | New Price | New xyz Annual Sales | New Price Index |
| 72495 | REGULAR COFFEE BIOPAK | $1.50 | 50 | $75.00 | $2.00 | $100.00 | 133.33 | 3 | 150 | $200.00 |
| 65782 | REUSABLE REGULAR COFFEE 285ML | $1.50 | 100 | $150.00 | $1.50 | $150.00 | 100 | 4 | 400 | $266.67 |
To achieve the same requirement, what you can do is to create a Power Apps [Canvas App] from Power BI Desktop which you can find in the visualization pane, and you need to manually create the application which fulfils this requirement.
Instead of Enter Data you can use SharePoint list as data source, refer that list as data source in Power Apps and provide a basic UPDATE functionality in the application.
As soon as he updates the value in the Power Apps Visual in Power BI, the sharepoint list value gets updated and then the value in the table visual in Power BI will also be updated & the measure you created will automatically compute the fresh value based upon the Updated "New Price" value.This is somewhat a reliable link pertaining to the same topic.
https://youtu.be/NTUfX9HNdK0
Thank you.
Let me know if you have any query regarding the same.
3 Replies
To achieve the same requirement, what you can do is to create a Power Apps [Canvas App] from Power BI Desktop which you can find in the visualization pane, and you need to manually create the application which fulfils this requirement.
Instead of Enter Data you can use SharePoint list as data source, refer that list as data source in Power Apps and provide a basic UPDATE functionality in the application.
As soon as he updates the value in the Power Apps Visual in Power BI, the sharepoint list value gets updated and then the value in the table visual in Power BI will also be updated & the measure you created will automatically compute the fresh value based upon the Updated "New Price" value.Thank you Vishal for the update will try the solution out. Are there any great sources that explain how to create the power APPS
This is somewhat a reliable link pertaining to the same topic.
https://youtu.be/NTUfX9HNdK0
Thank you.
Let me know if you have any query regarding the same.
