Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Cannot get multi row matrix in power bi report builder sorting correctly

Dear BI community,

 

I have created the below matrix in Power BI report builder. The rows are Area of Law, followed by Matter Name. The values are Client Name, Matter Start Date, and Sum of the Revenue in AOL. The matrix is ranked by the top 10 matters by revenue. I am trying to sort the matrix by revenue in Aol in Z to A order but it is not working as intended as below. I created the sorting through the group properties on the matter name row group. Could you please guide me as to how I can get it to sort correctly? Thank you so much for your help.