Forum Discussion
Power Bi and Python - Interactive user input with parameter
Hi , Truthahn195
According to your description, do you want to change the value of the parameter on the dashboard?
The parameters created in Power Query are generally used to modify the data source path. And the parameters created in Power Query are currently published to Power Bi Service, and only support modification in "Paramter".
And the parameter modification in Power Query generally involves the refresh of the dataset after modification. At present, it is not possible to modify it on the report page.
For more information, you can refer to :
Parameters - Power Query | Microsoft LearnSecondly, the what-if parameter in Power BI Desktop is generally used for slicers, which is equivalent to a fixed table imported into our report, and you can refer to the specific usage steps:
Power BI Parameters | How to Create and Use Parameters in Power BI? (wallstreetmojo.com)
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Dear Aniya,
thank you very much for your response. It seems to me that the user in Power Bi services has to go to the settings/configurations to adjust the value of the parameter. Is it also possible to create a slicer or something similar on the dashboard surface itself so the user can adjust the parameter without going to the setting?
When I added a parameter to the dashboard directly and added a slider to determine its value for the user in Power Bi Desktop, I was not able to insert it in the python code, therefore I wonder whether anything similar is possible.
Best, Peter
- v-yueyunzh-msft
Community Support
Hi , Truthahn195
According to your description, do you want to change the value of the parameter on the dashboard?
The parameters created in Power Query are generally used to modify the data source path. And the parameters created in Power Query are currently published to Power Bi Service, and only support modification in "Paramter".
And the parameter modification in Power Query generally involves the refresh of the dataset after modification. At present, it is not possible to modify it on the report page.
For more information, you can refer to :
Parameters - Power Query | Microsoft LearnSecondly, the what-if parameter in Power BI Desktop is generally used for slicers, which is equivalent to a fixed table imported into our report, and you can refer to the specific usage steps:
Power BI Parameters | How to Create and Use Parameters in Power BI? (wallstreetmojo.com)
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly