Forum Discussion

yashwant101's avatar
yashwant101
Helper III
8 months ago
Solved

Power BI Not Sorting column

Hi all,   I have below data in which I am trying to sort Time Period column by Time Period sort column. but getting below issue this is really frustrating as I have no duplicate values. ...
Show and Tell
Tips and Tricks
  • Anand24's avatar
    Anand24
    8 months ago

    yashwant101,
    Here's what you can do:
    1. Change the data type of column to whole number. Text will also sort it but based on ASCII ordering


    2. Easiest, Quickest, Safest for long-term model development: Create a separate time period sort order table with just these 2 columns, make sure sort order column is whole number. Create a relationship between any table's time period to this table's time period and use this table in visuals. Filtering for the relationship would be uni-directional from sort order table to any other table with it.

     

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn
PhilipTreacy's avatar
PhilipTreacy
Super User
8 months ago

yashwant101 

 

Your Time Period Sort column is text, so it won't sort properly anyway.  Change it to Whole Number 

 

 

As for the error message, it would indicate that there is a dupicate value(s) in the Time Period column.  Without seeing your data it's hard to say anymore.

 

Have you checked for rows with BLANKs?

 

Regards

 

Phil