Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 (Index 1) till 1 Jan 2017 (Index 227) .
I am loading in Reporting Builder 5 fields from the PowerBI dataset: Year (=YEAR([Date])) ClientType (text) Location(text) Project (text) Sector(text) using the Query
EVALUATE SUMMARIZECOLUMNS('ReferenceList'[Year], 'ReferenceList'[ClientType], 'ReferenceList'[Location], 'ReferenceList'[Project], 'ReferenceList'[Sector])
In Report Builder a Tablix is used and all 5 Fields are dropped in the Value box
The issue: The Sorting Order is not correct.
There are 5 pages and 46 lines per page. The first 3 pages is in ascending order till 1 jan 2017.
But then the Project Years start with 2021 , then 2020, then 2019, then 2022, then 2022 , then 2018...later 2023 the year are all over the place.
How can I force a sorting order (descending from Start dates 2023 -> 2017) either at the source data or in the Query ?
Many thanks !
Solved! Go to Solution.
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.