Forum Discussion

fanhui3's avatar
fanhui3
Helper I
5 years ago

Sort by column not working

Hi,  I created a sort column for my dataset and sort the data with that column. However, my date axis in my visual is still not sorted. Some help please? Thank you.    I will also enclose my PBI...
General Comment
Need Help
Tutorial Requests
mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

I downloaded your file and got it working from your existing Sort column.  In Data View, highlight/select the Month & Year column, then on the ribbon choose Sort By Column and choose the Sort column.  Then, if needed, hit the ellipsis on the visual and choose to sort it by Month & Year and Ascending.

 

Regards,

Pat

 

fanhui3's avatar
fanhui3
Helper I
5 years ago

Hi Pat! 

 

I did what you instructed and I still see the following. Any idea where else went wrong? 

 

 

 

  • FrankAT's avatar
    FrankAT
    Community Champion
    5 years ago

    Hi fanhui3 

    I downloaded your sample pbix file and got the following solution:

     

    1.  Select your column Sort and change the data type to whole number.
    2. In data view select your column Month & Year > tab Column tools > Sort by column > choose Sort.

    The sort order of the chart axis changes immediatly.

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

    • fanhui3's avatar
      fanhui3
      Helper I
      5 years ago

      HI FrankAT 

       

       

      At this point, I am starting to think there are problem with my software instead of the solutions. 

       

       

       

      • fanhui3's avatar
        fanhui3
        Helper I
        5 years ago

        Oh yea, I would like to add. The problem only persist in scattered graph. Weird.