You have a dataset that is populated from a list of business categories in a source database. The list of categories changes over time. You use Power BI Report Builder to create a paginated report…

This question tests how to configure a multi-value report parameter in Power BI Report Builder so it dynamically populates from a dataset and defaults to all values selected when the report opens.

Explore and visualize data

Question

You have a dataset that is populated from a list of business categories in a source database. The list of categories changes over time.
You use Power BI Report Builder to create a paginated report. The report has a report parameter named BusinessCategory.
You need to modify BusinessCategory to ensure that when the report opens, a drop-down list displays all the business categories, and all the business categories are selected.
How should you configure BusinessCategory? To answer, drag the appropriate options to the correct settings. Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Explanation

This question tests how to configure a multi-value report parameter in Power BI Report Builder so it dynamically populates from a dataset and defaults to all values selected when the report opens.

Approach. For 'Available Values', set the source to 'Get values from a query' and point it to the dataset containing business categories - this ensures the drop-down reflects the current state of the source database dynamically. For 'Default Values', also set the source to 'Get values from a query' using the same dataset and value field - this causes every value returned by the query to be pre-selected when the report loads. Critically, the parameter's General settings must have 'Allow multiple values' checked; without this, only a single selection is possible and the 'select all' default cannot work. Using a query-based default (rather than specifying values manually) is essential because the category list changes over time - hardcoded defaults would go stale.

Concept tested. Configuring dynamic multi-value parameters in Power BI Report Builder paginated reports: using query-based Available Values for a live drop-down, enabling 'Allow multiple values', and using query-based Default Values to pre-select all items at report open time.

Reference. Microsoft Learn - Report Parameters in Power BI Report Builder: 'Add, change, or delete a report parameter' and 'Set a multivalue parameter for a report'

Topics

#Power BI Report Builder#Paginated Reports#Report Parameters#Default Values

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice