Forum Discussion
Paginated Report using Power BI Dataset | Query from Performance Analyser- Report & Query Parameters
hi,
1.Yes, you should create report parameters for the slicers you want to include in your paginated report. These parameters will allow users to filter the data dynamically. You can create parameters based on the tables (e.g., Region, District, Store) used for slicing.
2. It's a good practice to bring distinct values for your parameters to avoid redundancy and improve user experience. You can achieve this by writing queries to retrieve distinct values from your dataset tables and then use those queries as datasets for your report parameters.
3.After creating report parameters, you need to pass these parameter values to your dataset query to make it dynamic. You'll create query parameters in your 'ds_DAXQuery' dataset query and reference the report parameters you've created.
4.In the Parameters tab of the 'ds_DAXQuery' dataset properties, you'll map your query parameters to the report parameters you've created. This ensures that the parameter values selected by the user are passed to the dataset query.
5.If you have parameters that allow multiple selections (e.g., multi-select slicers), you'll need to adjust your dataset query to handle these multiple values. Depending on your data source and query language, you may need to use functions like IN or OR to filter your data accordingly.
If this helped, Follow this blog for more insightful information about data analytics
Analytic Pulse
hi,
1.Yes, you should create report parameters for the slicers you want to include in your paginated report. These parameters will allow users to filter the data dynamically. You can create parameters based on the tables (e.g., Region, District, Store) used for slicing.
2. It's a good practice to bring distinct values for your parameters to avoid redundancy and improve user experience. You can achieve this by writing queries to retrieve distinct values from your dataset tables and then use those queries as datasets for your report parameters.
3.After creating report parameters, you need to pass these parameter values to your dataset query to make it dynamic. You'll create query parameters in your 'ds_DAXQuery' dataset query and reference the report parameters you've created.
4.In the Parameters tab of the 'ds_DAXQuery' dataset properties, you'll map your query parameters to the report parameters you've created. This ensures that the parameter values selected by the user are passed to the dataset query.
5.If you have parameters that allow multiple selections (e.g., multi-select slicers), you'll need to adjust your dataset query to handle these multiple values. Depending on your data source and query language, you may need to use functions like IN or OR to filter your data accordingly.
If this helped, Follow this blog for more insightful information about data analytics
Analytic Pulse