Forum Discussion
Impactful IndividualParameters in Power BI
can it possible to create report in power bi which ask for user input or parameters
Yes, it is possible to create reports in Power BI that ask for user input or parameters. Power BI supports the use of parameters to make reports more dynamic and interactive. Here are a few ways to achieve this:
Query Parameters: You can create parameters in Power Query Editor. These parameters can be used to filter data or change the behavior of queries. Users can input values for these parameters when they refresh the data.
What-If Parameters: Power BI allows you to create What-If parameters that can be used to perform scenario analysis. These parameters can be adjusted by users through slicers in the report.
Dynamic M Query Parameters: This feature allows users to input values that are then passed to the underlying M queries, enabling dynamic data retrieval based on user input.
2 Replies
- bhanu_gautam
Super User
Yes, it is possible to create reports in Power BI that ask for user input or parameters. Power BI supports the use of parameters to make reports more dynamic and interactive. Here are a few ways to achieve this:
Query Parameters: You can create parameters in Power Query Editor. These parameters can be used to filter data or change the behavior of queries. Users can input values for these parameters when they refresh the data.
What-If Parameters: Power BI allows you to create What-If parameters that can be used to perform scenario analysis. These parameters can be adjusted by users through slicers in the report.
Dynamic M Query Parameters: This feature allows users to input values that are then passed to the underlying M queries, enabling dynamic data retrieval based on user input.
- Ritaf1983
This really depends on what you mean by "parameters":
-
If you're referring to creating scenarios or "what-if" analyses, this is definitely possible using the "What-if parameters" feature in Power BI.
You can find an example in this video :
https://www.youtube.com/watch?v=6a_5uderwAgIf you're interested in allowing end-users to dynamically select dimensions or measures in visuals, you should use "Field parameters".
Here's a video with the example :
https://www.youtube.com/watch?v=-nqEv2YXLsU&t=18s -
However, if you're referring to Power Query parameters (query parameters used during data load), those parameters can't be adjusted by end-users after publishing to the Power BI Service. They only work during data refresh in Power BI Desktop.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
-
