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.

      • kgriendling's avatar
        kgriendling
        Advocate I
        9 years ago

        I am no database expert but that seems like a major oversight to me... Wouldn't all programs start withOUT modification to the list, then allow users to modify the list with features? Odd. But I can do that... Thanks!