Question 370
A Power BI reviewer must sign off the following requirement: A reporting model needs month names ordered January through December, not alphabetically. After this change—Set MonthName to Sort by Column using its corresponding numeric MonthNumber.—what outcome validates it?
Explanation
Correct Answer
This checks the actual result rather than a saved setting. Sort by Column allows display labels to follow numeric business sequence. A failed implementation may show: Sorting MonthName as text produces April before February.
Incorrect Answers
The prior-year value for March 2026 aligns to March 2025 under normal calendar rules. However, this does not establish the required outcome: a month slicer displays Jan through Dec in chronological order across years as intended.
June year-to-date equals the sum from the beginning of the relevant year through June. However, this does not establish the required outcome: a month slicer displays Jan through Dec in chronological order across years as intended.
A ShipDate-specific measure filters on shipping dates while the default order measures use OrderDate. However, this does not establish the required outcome: a month slicer displays Jan through Dec in chronological order across years as intended.