Ready to curb your Power BI skills? Find out more here!

Curbal

Learn how to grow your business with your data and Power BI

You are here: Home / Knowledge Base / How to solve sort order error: “We cannot sort the ‘A’ column by ‘B’. You cant have more than …”
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

How to solve sort order error: “We cannot sort the ‘A’ column by ‘B’. You cant have more than …”

Posted
Updated
ByRuth Pozuelo Martinez

Have you got this error while trying to sort columns?:

“We cannot sort the ‘school’ column by ‘grade’. You can’t have more than one value in ‘grade’ for the same value in ‘school’. Choose a different column for sorting or update the data in ‘Year’.”

In this video I show you why you get it and how to fix it.

Watch the tutorial:

How to solve sort order error: "We cannot sort the 'A' column by 'B'. You cant have more than ..."

Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents