Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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)
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??
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.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 98 | |
| 72 | |
| 50 | |
| 49 | |
| 42 |