Forum Discussion
Paginated Report Matrix Doesn't Sort Correctly
Hi. I'm new to paginated reports. My paginated report will not sort correctly. My data source is a PBIX file. I created an interactive sort in Power BI Report Builder on the Total column. I have customer name in the rows (hidden in screenshot), Month of Invoice in the columns and a DAX measure Invoice Amount in the data area. The report is sorted in ascending order. I have yellow highlighted the two rows that are out of order. It looks to me like the rows are sorting based upon the value of the individual amounts in the respective columns of each row. For example, the $9,019 total amount is made up of one invoice of $9,019 (May 21 column), which is greater than any of the individual amounts on the row that totals $11,097 (columns Mar 21, Apr 21, May 21), thus it appears after the $11,097 row.
Is this the correct behavior of the Matrix visual in Power BI Report Builder or have I not done something correctly?
Thank you.
AJ
Here is the same report published to the service from Power BI Desktop sorted correctly:
2 Replies
Hi GilbertQ. Thank you for your reply. I actually did what I believe you are suggesting before I posted to this forum. I went to TextBox Properties in Report Builder Design mode and created an Interactive Sort. See screenshot below:
When I publish the report the interactive sorting works except for the two rows highlighted in yellow above. That is the issue that I am trying to solve. Still looking for a solution. Thanks again.
