How to write to power BI DASHBOARD

[preethisaldanha]

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

[VishalJhaveri · Accepted solution]

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.

[preethisaldanha]

Thank you Vishal for the update will try the solution out. Are there any great sources that explain how to create the power APPS

[VishalJhaveri · Accepted solution]

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.

[VishalJhaveri · Accepted solution]

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.