Power BI Report Filter Types - PL-200 Exam Preparation | Microsoft Power Platform Functional Consultant

Power BI Report Filter Types

Question

You review a Power BI report in Reading view mode. What filter type can you add to the report?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E. F.

Correct Answer: B

You can interact with Power BI reports in two view modes: Editing and Reading.

Power BI provides the four types of filters to use in the reports: Report - this type applies to all the pages in the report.

Page - this type applies to all tiles on the current report page.

Visual - this type applies only to a single tile.

Drillthrough - this type allows additional details on a specific tile.

In Editing mode, you can add any of the four filter types.

When you save a report, filters are also saved with the report.

In Reading mode, users can interact with a report and use the filters saved with a report in Editing mode but cannot add or remove them.

All other options are incorrect.

For more information about Power BI filters, please visit the below URLs:

When reviewing a Power BI report in Reading view mode, you can add a filter type to refine the data displayed in the report. The available filter types are:

A. Report filter: This filter applies to the entire report and is useful when you want to limit the data displayed in all visuals on the report. When you apply a report filter, all visuals in the report update to reflect the selected data.

B. None: You can also choose not to add any filter to the report, which means that all data in the report is displayed without any filtering applied.

C. Drillthrough filter: This filter allows you to create a hierarchy in your report and drill down to more detailed data. When you click on a data point in a visual, it can take you to another report page or visual that shows more detailed data related to the selected data point.

D. Page filter: This filter applies to a specific page in the report and is useful when you want to limit the data displayed in visuals on that page. When you apply a page filter, only the visuals on the selected page update to reflect the selected data.

E. Dashboard filter: Dashboard filters apply to all visuals in a dashboard and are useful when you want to limit the data displayed in all visuals on the dashboard. When you apply a dashboard filter, all visuals in the dashboard update to reflect the selected data.

F. Visual filter: This filter applies to a single visual and is useful when you want to limit the data displayed in that specific visual. When you apply a visual filter, only the selected visual updates to reflect the selected data.

Therefore, the correct answer to the question is F. Visual, as this is one of the filter types that can be added to a Power BI report in Reading view mode.