Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have the below matrix but I am having issues sorting it the way that the user has required.
I want the matrix to show the 6 months of revenue first then the 6 months of billing rather than side by side so I know I need to sort on something other than month.
The solution should look similar the pivot table below, but instead of having 'HRS weighted' & 'HRS', I would have Revenue & Billing. Does anyone know how to do this in Power BI? I have briefly tried calculation groups already but can't seem to work it out yet.
MATRIX:
PIVOT TABLE:
Any help would be greatly appreciated.
Thanks,
Shaun
Solved! Go to Solution.
Hi,
you'll need to create a new table with the sorting order for you columns and then use sort by in the column tools to adjust it to that order. I wrote a blog which includes how to do this, check out: https://github.com/DOLEARY85/Power-BI-Replicate-Excel-Table
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
you'll need to create a new table with the sorting order for you columns and then use sort by in the column tools to adjust it to that order. I wrote a blog which includes how to do this, check out: https://github.com/DOLEARY85/Power-BI-Replicate-Excel-Table
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thanks so much, I didn't actually need to do anything with the sorting. Duplicating & Unpivoting did the trick by itself.
Great Blog Post 🙂
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
71 | |
70 | |
43 | |
31 | |
26 |
User | Count |
---|---|
89 | |
49 | |
44 | |
38 | |
37 |