Forum Discussion
Matrix Sorting Multiple Columns and Values
Hi. Long time Excel / Power Query users coming over to Power BI. In Excel, sorting pivot tables at multiple layers is as easy as right clicking and selecting sort. In the visual below, I would like...
Let me see if I can explain it better. I want to sort by year, then month, then Count of Case ID (see visual below). I can find no way to add that 3rd sort layer. If you see the red line bracket outling Count of Case ID....they are not sorted largest to smallest. I want them sorted 216, 122, 21, 15....etc. In excel this is super simple. Can't find a way to do it in PBI. Is it doable??