Forum Discussion

Egrofal's avatar
Egrofal
Helper I
9 years ago
Solved

Sort table by date

Hi,   I am using Power Bi for my company, and have to create dashbord with several table sorted by date, I got a date picker table and some other tables. And on these tables I would like to sort a...
  • Egrofal's avatar
    Egrofal
    9 years ago

    So to help people who got the same problem, the best way to resolve it at the moment is to place the column on the right of the board, go to the focus mode and hide it on the left

    On this way my table's tab looks like that :

     

    So Date is hiden, (you just see a small part of the tab)

     

    It's not perfect, but I don't have any idea to do better...

Egrofal's avatar
Egrofal
Helper I
9 years ago

no idea ?

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

    Egrofal

     

    If you want the cost column to be sorted by day column, you need to first select the cost column and then click “Sort By Column” - “date_days” as below.

     

     

    Best Regards,

    Herbert

    • Egrofal's avatar
      Egrofal
      Helper I
      9 years ago

      Hi Herbert,

       

      Thanks for your answer,

      I tried but when I select the column "cost" then sort it by "date" I have a error message :

       

      "We cannot sort the 'cost' column by 'date_day'. You can't have more than one value in 'date_day' for the same value in 'cost'. Choose a different column for sorting or update the data in 'date_day'.

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        9 years ago

        Yeah, I've seen that one and it can be frustrating. Perhaps if you create a new column with Date and a random timestamp you could get some unique values for sorting purposes. I think you would have to create that column in your Query however in Power Query "M" language as I do not believe that DAX has a RANDOM function.