BenchMark Quizzes by MDFT Pro

Filter Report Data By Country

You are a business intelligence analyst for MDFT Pro, a well-known training organization. MDFT Pro operates globally and regularly analyzes sales data to improve its training offerings and reach new students.

You have created a Power BI report that visualizes sales data for the entire organization. Now, you have been asked to provide a version of this report that only displays data for a single country, so that local managers can focus on their region’s performance.

What should you do to provide a filtered version of the report for a specific country?

Choose all correct answers from the options below.

Explanations for each answer:

Add a report-level filter, share the report, and check the Include my changes option is correct. The Include my changes option creates a bookmark to filter the report data. The URL emailed when sharing includes this bookmark, preserving the filter.
Add a dataset parameter to filter by country and add a query string parameter specifying the dataset parameter and country is incorrect. Power BI datasets do not support setting dynamic dataset parameters with query string parameters. You can only use the query string to refer to tables and fields directly
Add a query string parameter specifying the table/field and country is correct. Query string parameters in the URL can pre-filter the report. You can specify table and fields to restrict data by country name.
Export the report to PDF and manually remove data for other countries is incorrect. Exporting to PDF creates a static snapshot of the report. This does not allow interactive filtering or sharing a dynamic, filterable report with others.

Learn more about filtering Power BI reports with query string parameters:

Power BI Data Filtering

Exam Preparation Quiz

Filter Report Data By Country