Forum Discussion
Reorder Columns in Matrix (Change the group)
Hello Community,
I would like to change the group order of columns in my matrix below :
In every quarter, I want to have Total Production Sales First (Together) then the Ratios.
Is it possible to reorder this?
Edited at 10.18 :
I aim to have my matrix as below :
Thank you !
Hello! You can achieve something similar using calculation groups. The meaure name appears on top and the year-qtr is below it:
Here is a blog I wrote about calculation groups. Since writing it, there has been an update to Desktop that allows you to now create calculation groups in Desktop, but the same logic basic steps apply: http://powerbiwithme.com/2023/08/10/the-calculation-group-edition/
Keep in mind, in desktop this is still in preview so you will have to enable it, but here is how to create them in desktop: Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn
1 Reply
- audreygerred
Super User
Hello! You can achieve something similar using calculation groups. The meaure name appears on top and the year-qtr is below it:
Here is a blog I wrote about calculation groups. Since writing it, there has been an update to Desktop that allows you to now create calculation groups in Desktop, but the same logic basic steps apply: http://powerbiwithme.com/2023/08/10/the-calculation-group-edition/
Keep in mind, in desktop this is still in preview so you will have to enable it, but here is how to create them in desktop: Create calculation groups in Power BI (preview) - Power BI | Microsoft Learn