nerdexam
Microsoft

PL-900 · Question #97

You need to display sales orders greater than a specific threshold in a Power BI report. What should you use?

The correct answer is A. filter. To display only sales orders greater than a specific threshold in a Power BI report, you should apply a filter directly within the report.

Submitted by kavita_s· Apr 18, 2026Describe the business value of Microsoft Power Platform

Question

You need to display sales orders greater than a specific threshold in a Power BI report. What should you use?

Options

  • Afilter
  • BPower Query
  • CCommon Data Service
  • Dconnector

How the community answered

(38 responses)
  • A
    89% (34)
  • B
    8% (3)
  • C
    3% (1)

Why each option

To display only sales orders greater than a specific threshold in a Power BI report, you should apply a filter directly within the report.

AfilterCorrect

Filters in Power BI allow you to specify criteria to include or exclude data points, such as sales orders above a certain threshold, directly within the report's visuals, pages, or the entire report. This is the most direct and efficient method for controlling what data is displayed to the end-user in the report view.

BPower Query

Power Query is used for data transformation and shaping *before* the data is loaded into the Power BI model, which could be used to remove data, but filtering is the specific and direct tool for display criteria *within* the report itself.

CCommon Data Service

Common Data Service (now Microsoft Dataverse) is a data storage platform and does not directly provide a mechanism for displaying filtered data within a Power BI report.

Dconnector

A connector is used to establish a connection to a data source, not to filter data for display within a Power BI report.

Concept tested: Power BI report filtering

Source: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-reports-filters

Topics

#Power BI#Filtering#Reports#Data display

Community Discussion

No community discussion yet for this question.

Full PL-900 Practice