Forum Discussion

Swalker's avatar
Swalker
Frequent Visitor
3 years ago
Solved

Sortorder in Report Builder

Hi,   In Power Bi I have a FactTable of 227 project records with Start Dates starting from 1 Jan 2017 till 26 jan 2023. In PQ i added an Index Column starting from latest Start Date  26 jan 23 (Ind...
[help needed]
[Report Builder]
[Sorting Order]
  • Swalker's avatar
    Swalker
    3 years ago

    I have solved this issue as follows:

     

    EVALUATE SUMMARIZECOLUMNS('ReferenceList'[Index],'ReferenceList'[Year], 'ReferenceList'[ClientType], 'ReferenceList'[Location], 'ReferenceList'[Project], 'ReferenceList'[Sector]) ORDER BY 'ReferenceList'[Index] ASC

     

     

    * include column [Index] in EVALUATE statement 

    * use ORDER BY [Index] ASC 

Swalker's avatar
Swalker
Frequent Visitor
3 years ago

I have solved this issue as follows:

 

EVALUATE SUMMARIZECOLUMNS('ReferenceList'[Index],'ReferenceList'[Year], 'ReferenceList'[ClientType], 'ReferenceList'[Location], 'ReferenceList'[Project], 'ReferenceList'[Sector]) ORDER BY 'ReferenceList'[Index] ASC

 

 

* include column [Index] in EVALUATE statement 

* use ORDER BY [Index] ASC