How to group years in matrix table rows as in excel pivot table

[Anonymous]

Hi community, 

Can anyone help me to group all rows before a certain year into one row, which then summarizes the values for these year. This is possible in excel pivot table, when right clicking the rows and then use group by - but the group function is disabled when I try in Power BI. 

So here is the table I have and I would like for alle years before 2010 to be grouped into one row called "<2010":

Like this (from excel):

Thank you in advance 😊

[Anonymous]

This was exactly what I was looking for. Thank you very much 🙂 

[Anonymous · Accepted solution]

Hi  @Anonymous ,

I created some data:

Refer to:

Use grouping and binning in Power BI Desktop - Power BI | Microsoft Learn

How to enable group on desktop - Microsoft Power BI Community
"new" group function is greyed out - Microsoft Power BI Community

Here are the steps you can follow：

1. Select the yellow label for [Year] – New group.

2. Go to the Groups interface.

Group type – List

Multi-select marks for years less than 2010 using Ctrl + left mouse button – Group.

Each of the rest of the year is a separate group.

Result：

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly