Bird
0
0

A user applied 'Sort by Column' to sort 'MonthName' by 'MonthNumber' but the months appear out of order. What is the most probable error?

medium📝 Formula Fix Q7 of 15
Power BI - Power Query Editor
A user applied 'Sort by Column' to sort 'MonthName' by 'MonthNumber' but the months appear out of order. What is the most probable error?
A'MonthName' column contains typos
B'MonthNumber' column has missing values
CThe 'Sort by Column' was applied on 'MonthNumber' instead of 'MonthName'
D'MonthNumber' column is stored as text, not number
Step-by-Step Solution
Solution:

  1. Step 1: Check data type of sorting column

    If 'MonthNumber' is text, sorting will be alphabetical, causing wrong order.

  2. Step 2: Understand sorting behavior

    Sorting numbers stored as text sorts lexicographically, not numerically.

  3. Final Answer:

    'MonthNumber' column is stored as text, not number -> Option D

  4. Quick Check:

    Sorting numeric data requires numeric type [OK]
Quick Trick: Ensure sorting column data type matches expected order [OK]
Common Mistakes:
  • Ignoring data type mismatches
  • Applying sort on wrong column
  • Assuming typos cause sorting errors

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Basic Visualizations - Table and matrix visuals - Quiz 11easy Basic Visualizations - Gauge visual - Quiz 6medium Basic Visualizations - Pie and donut charts - Quiz 15hard Data Cleaning with Power Query - Unpivoting columns - Quiz 11easy Formatting and Design - Page layout and canvas settings - Quiz 12easy Getting Data - Excel data import - Quiz 4medium Power BI Basics and Architecture - Power BI Desktop vs Service vs Mobile - Quiz 13medium Power BI Basics and Architecture - Power BI workflow (get data, transform, visualize, share) - Quiz 12easy Power Query Editor - Column operations (rename, remove, reorder) - Quiz 3easy Power Query Editor - Power Query interface overview - Quiz 10hard