Forum Discussion
User to enter data into Power Bi Report?
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.
- mariussve13 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.
- 1up3 years agoResolver I
Hi Adam, reading the step by step instructions, this solution seem to focus on the users that have access to the source data and can update them. How do you see it?
I am trying to locate a solution for report viewers to enter their custom data directly into an existing report visual or equivalent, which would just be stored for that particular session basically.