Forum Discussion

ctrlaldelight's avatar
ctrlaldelight
Frequent Visitor
6 months ago
Solved

Order Projects by date

I have one project where my database is an online Excel file, but the projects are sorted alphabetically rather than by date. I would like to sort them by ‘DATA FIM DE OBRA.’ Is this possible? ...
Need Help
  • MFelix's avatar
    MFelix
    6 months ago

    Hi ctrlaldelight ,

     

    Add the Data da Obra Column before the Projecto ojn the Category. If you want you can hide that column just resizing the column or do a hierachy layout

     

    Please see file attach.

danextian's avatar
danextian
Super User
6 months ago

Hi ctrlaldelight 

Your pbix isn't accessible from my end. 

That aside, you can use an External tool called Tabular Editor to sort the same distinct project value multiple times which the Power BI GUI doesn't allow. Bear in mind though that the projects will be displayed in separate rows according to their actual and sort by value

Notice in the image below, that the same projects are displayed multiple times and are sorted according to the Date column without this column being sorted.

Alternatively, you can precede the project name with an invisible character  repeated multiple times depending on the date rank in desc order

Project2 = 
VAR dateRank =
    RANKX ( 'Table', 'Table'[Date],, DESC, DENSE )
RETURN
    REPT ( UNICHAR ( 8203 ), dateRank ) & 'Table'[Project]