Blog Post

Power BI Community Blog
3 MIN READ

Power BI Tip: How To Sort A Column With Duplicates By Another Column

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
3 years ago
Hi There, If a column in your table has duplicate values, Power BI won’t allow you to sort it by another column, unless both columns have the same granularity. To set a different column to sort by...
Updated 3 years ago
Version 4.0
how to
tips & tricks
Fowmy's avatar
Icon for Super User rankSuper User
I’m a Microsoft-certified BI professional with a solid background in finance, accounting, and data analytics. My main focus is on Power BI and Microsoft Fabric development, where I work on building BI solutions, consulting, and corporate training. I enjoy helping others develop their skills in data analytics and stay active in community forums to keep up with the latest trends and best practices in the field.
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
RobG123's avatar
RobG123
Icon for Helper I rankHelper I
2 years ago

Thanks for this. I'm getting the 'we can't sort the character column by order column error. But in my data there are no duplicated order values for values in my character column. This is a matrix count for the two columns

Do you know how I could fix this? I want to sort a slicer by Grade in the order shown by numbers, not alphabetical