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...

Greg_Deckler's avatar
Greg_Deckler
Community Champion
9 years ago

Not sure, here is an example of a Value sorted by Date without Date in the visual, just Value sorted by Date.

 

Egrofal's avatar
Egrofal
Helper I
9 years ago

Thanks OK, it seems working on your graph, but for me it's not.

 

Maybe, I did something wrong....

 

Here, some screeenshots :

 

My Data model sorted by day : 

 

My values of my report table : 

 

 

My report table with the date (so it's correctly sorted) : 

 

 

 

Then, I delete the column "date"

 

 

And my final report table (who is not sorted correctly anymore) : 

 

 

Anyway, thanks for your help, I appreciate :)