Forum Discussion

bdoiron's avatar
bdoiron
Frequent Visitor
9 years ago
Solved

Problem sorting report

 I have a sql table as a datasource for my dashboard. Columns are Sort Order (Integer) and ItemDesc  as (Text)                                              (1)  138410     A1_Trenching (2)  138415 ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi bdoiron,

     

    To sort column "ItemDesc" by column "Sort Order", you need to select column "ItemDesc" first, then click Sort by Column under Modeling tab, and choose "Sort Order". :smileyhappy:

     

     

    Regards

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Can you set the Sort By field for ItemDesc to SortOrder?

  • bdoiron's avatar
    bdoiron
    Frequent Visitor
    9 years ago

    When I am in table view or query sort order is selected for sorting and the data view shows itemdescr in the correct order

    A1,A2,.........A10 But when I go back to my visual (report) view it is sorted by itemdescr.

    • bdoiron's avatar
      bdoiron
      Frequent Visitor
      9 years ago

      Also i find that if my visual is a bar chart I can click on the .... ellipses on the the upper right and sort order is available but I need the visual in a table format and when I switch and do the same thing sorting is not available. Why shouldnt the query order the data????