Forum Discussion

gesbos1's avatar
gesbos1
Regular Visitor
3 years ago

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 to first sort by the Year/Month Column and then by the Count of Case ID in descending order. How can i do this? (hopefully in an easy straight-forward way like excel)

 

 

 

Need Help

2 Replies

  • vicky_'s avatar
    vicky_
    Super User
    3 years ago

    If you hover over the visual, you can go to the top-right corner and click on ... > sort by > Count CaseID or you can click on the header for Count CaseID.

  • gesbos1's avatar
    gesbos1
    Regular Visitor
    3 years ago

    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??