Forum Discussion
Power BI - User Data input & Display calculated result
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.
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.