Power BI - Power Query Editor
Why does Power BI require the 'Sort by Column' sorting column to have unique values when sorting another column?
Why does Power BI require the 'Sort by Column' sorting column to have unique values when sorting another column?
hard📝 Conceptual Q10 of 15
Step-by-Step Solution
Solution:
Step 1: Understand sorting logic in Power BI
Sorting by a column uses that column's values to order the target column.Step 2: Recognize impact of duplicate values
If sorting column has duplicates, Power BI cannot determine a clear order, causing ambiguity.Final Answer:
Because duplicate values cause ambiguous sorting order -> Option BQuick Check:
Unique values needed to avoid ambiguous sorting [OK]
Quick Trick: Sorting column must have unique values to avoid confusion [OK]
Common Mistakes:
- Thinking sorting columns must be measures
- Believing text columns cannot be sorting columns
- Assuming sorting columns must be hidden
Master "Power Query Editor" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes