Forum Discussion
1up
3 years agoResolver I
User to enter data into Power Bi Report?
Hello, these days, is there any functionality within Power Bi for users of a report to enter data? Consider below example where field Customer Number would be pre-populated with data, while the Sa...
Adamboer
3 years agoResponsive Resident
Yes, it is possible to create a table where users can manually enter data in Power BI. Power BI allows users to create data entry forms that allow users to enter data and update tables in real-time.
Here's how you can achieve this:
- Create a table with the necessary columns (e.g., Customer Number and Sales 2022).
- Create a new page in your report and add a table visual to it.
- Add the necessary fields to the table visual (e.g., Customer Number and Sales 2022).
- Under the modeling tab, click on the "New Measure" button.
- Enter the formula for the measure you want to create (e.g., Total Sales = SUM('Customer'[Sales 2022])).
- Under the "Visualizations" pane, click on the "Fields" button and select the "New Quick Measure" option.
- Select the "SUMX" aggregation function and drag the "Customer Number" field to the "Values" field well.
- Drag the newly created measure to the "Values" field well as well.
- Your table visual should now show the total sales for each customer.
- Publish your report to Power BI service and share it with your users.
Your users can now enter their own data into the Sales 2022 column, and the Total Sales measure will update accordingly. The entered data will be saved in the report, and you can use it for further calculations or analysis.
mariussve1
3 years agoSolution Sage
Is this something chat gpt answers? Maybe Im wrong, but I got a feeling that you just pasted a answer from chat gpt.