PL-300 Question #64: Real Exam Question with Answer & Explanation

Question

From the Home tab in Power BI Desktop, you click Enter Data and create a table named Sales that contains the following data. You add Region and Sales to visualization and the visualization displays the following data. What causes the visualization to display four rows of data instead of six?

Options

• Athe Data Category of Region
• Bthe Default Summarization on Region
• Cthe Default Summarization on Sales
• Dthe Data Category of Sales

Explanation

A visualization displaying four rows instead of six when using Region and Sales indicates that data is being grouped by distinct Region values.

Common mistakes.

• A. The Data Category of Region helps with geographical mapping but does not cause aggregation or reduction in row count in this context.
• C. The Default Summarization on Sales determines how the numeric 'Sales' values are aggregated (e.g., summed) within each group, but it is not the primary cause of the reduction in the number of rows from six to four, which is driven by the grouping of the 'Region' field.
• D. The Data Category of Sales (numeric) is irrelevant to how rows are grouped or reduced in a visual.

Concept tested. Power BI visual aggregation and grouping

Reference. https://learn.microsoft.com/en-us/power-bi/create-reports/service-analyze-data#aggregate-data

No community discussion yet for this question.