New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

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

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?
Previous What are calculated tables in Power BI and how to use them?

Reader Interactions

Let us know your thoughts...

Table of Contents