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
yashwant101's avatar
yashwant101
Helper III
8 months ago

Hi all,

 

Thank you for your responses. It might have been some transient issue. I let Power BI sleep over it and now I am able to sort without any change.😊

PhilipTreacy's avatar
PhilipTreacy
Super User
8 months ago

yashwant101 

 

I'm curious how sorting works as intended when the sort column is text, not numeric.  Text won't sort the periods the way you want.

 

Also why an answer was chosen as a solution when you say you did nothing to 'fix' the issue?

 

Puzzled.

 

Phil