Forum Discussion

kevmueller74's avatar
kevmueller74
Regular Visitor
2 years ago
Solved

Grouping Matrix by Measures then Time Period

In the basic matrix in Power BI I can't find a way to group the columns by the measures and then the time period. What you get by default is the time period and then all the measures and then the nex...
Need Help
  • audreygerred's avatar
    audreygerred
    2 years ago

    Hello! You can achieve this by using calculation groups. 

    In the below screenshot, I have the calculation group in first in column, then my year:

     

    Here is a blog I wrote about calculation groups: http://powerbiwithme.com/2023/08/10/the-calculation-group-edition/ When I wrote it, you still needed Tabular Editor 2, but now you can create them directly in Power BI Desktop (just make sure the preview feature is enabled).

audreygerred's avatar
audreygerred
Icon for Super User rankSuper User
2 years ago

Hello! You can achieve this by using calculation groups. 

In the below screenshot, I have the calculation group in first in column, then my year:

 

Here is a blog I wrote about calculation groups: http://powerbiwithme.com/2023/08/10/the-calculation-group-edition/ When I wrote it, you still needed Tabular Editor 2, but now you can create them directly in Power BI Desktop (just make sure the preview feature is enabled).