Forum Discussion

kgriendling's avatar
kgriendling
Advocate I
9 years ago
Solved

How Do I Avoid Alphabetical Sorting?

Hi All,   Total BI Newbie here. I have a list of costs being fed into my report, and it auto-sorted to alphabetical. I want it to show as its native sorting. How do I control this? The arrow on the...
  • Anonymous's avatar
    Anonymous
    9 years ago

    You need a numeric or alphabetic column that corresponds to that original sort order, then use that to sort.

kgriendling's avatar
kgriendling
Advocate I
9 years ago

Hi, 

 

I am a newbie to Power BI. How do I sort my list of data in the TABLE visualization by the source spreadsheet, and not alphabetically?

 

Thanks,

 

Kevin

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    kgriendling,

     

    You coud create a sort columd based on your requirement, and then change the order in your table visual.

     

    Regards,

    Charlie Liao

    • kgriendling's avatar
      kgriendling
      Advocate I
      9 years ago

      Thanks Charlie.

       

      This would work if I want it to sort by a certain column. But how do I get it to NOT sort. We have a specific order the original file is in, and we want it to show up that way, which is non-alphabetical nor numerical.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        You need a numeric or alphabetic column that corresponds to that original sort order, then use that to sort.