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 Anand24 ,

 

these two columns are present in same table where each value in Time Period is mapped to 1 value in Time Period sort

sergej_og's avatar
sergej_og
Super User
8 months ago

Hey yashwant101 ,
that might be the "issue" - having unique value for each "Time Period"...btw, your "date table" is looking very special.
What if you convert your Sort column into a number (looks like it is a text formated value) and try to get your sorting in another way. Maybe directly on the visual.
We don't know your intension with that.

Regards