Forum Discussion
Power BI - User Data input & Display calculated result
Hi Community,
Is it possible for users to input values in a published Power BI dashboard, have the dashboard process these values with simple calculations, and then display the results?
For example, assuming we have multiple clients and their performance data is already input, I would like to create a dashboard where users can enter the transaction participation rate(0~100%) for each client. The dashboard would then use these inputs to calculate and display the total business revenue.
For instance, given the following data, the participation rate is initially absent and must be entered by the user directly in the published dashboard. Once the user inputs the rates, the dashboard should return the result of SUMPRODUCT(performance, participation rate).
Client | Revenue(100%) | Our Participation(%) |
A | 100 | 20% |
B | -30 | 30% |
C | 50 | 20% |
Would it be possible to implement this functionality in Power BI?
Are you trying to write the data back to a data source such as SQL?
I think Power BI doesn't natively support direct user input within a published dashboard for calculations. However, there are a few workarounds you can use to achieve similar functionality:
What if parameters: I have never done it but I think Power BI allows you to create What-If parameters that users can adjust using slicers. These parameters can be used in calculations to simulate user input. However, this approach is limited to predefined ranges and increments.
Power Apps Integration: You can embed a Power App within your Power BI report. Power Apps allows for user input, and you can use this input to perform calculations and then display the results in Power BI. This method provides more flexibility and interactivity. However, Power Apps comes at a cost per user and you also need to understand how to use Power Apps.
R or Python Scripts: If you are comfortable with Python, you can create custom visuals that accept user input. This approach requires more advanced knowledge and may not be as seamless as using Power Apps, but it is possible.
2 Replies
Are you trying to write the data back to a data source such as SQL?
I think Power BI doesn't natively support direct user input within a published dashboard for calculations. However, there are a few workarounds you can use to achieve similar functionality:
What if parameters: I have never done it but I think Power BI allows you to create What-If parameters that users can adjust using slicers. These parameters can be used in calculations to simulate user input. However, this approach is limited to predefined ranges and increments.
Power Apps Integration: You can embed a Power App within your Power BI report. Power Apps allows for user input, and you can use this input to perform calculations and then display the results in Power BI. This method provides more flexibility and interactivity. However, Power Apps comes at a cost per user and you also need to understand how to use Power Apps.
R or Python Scripts: If you are comfortable with Python, you can create custom visuals that accept user input. This approach requires more advanced knowledge and may not be as seamless as using Power Apps, but it is possible.
Thanks a lot. this is what i wanted to know exactly.