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.
Question
Options
- Afilter
- BPower Query
- CCommon Data Service
- Dconnector
How the community answered
(38 responses)- A89% (34)
- B8% (3)
- C3% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.