How to group columns by year in a Matrix or Table

[Alejanito]

Hi, 

I have created a matriz where:

- Rows: Product Category

- Columns: Sales Channel By Year 2021 and 2022

- Values: Gross Sales

Would it be possible to group my channels by Year?

So I can see Year Over Year:

GS Amazon Vendor 2021-2022 together,

then GS Leroy Merlin 2021-2022 together

And so on...

It is much easier to see what happens in each channel year over year.

Thanks. 

[v-shex-msft · Accepted solution]

HI @Alejanito,

You can try to create a new table with all measure names, then use this field on matrix columns and above the year field.

After these steps, you can write a measure formula to extract the current row and column values and use them as conditions to look up and calculate raw table values based on current categories.

Dynamic Rows and Dynamic Columns in Power BI Matrix visual using Slicers | by Raghvendra Pratap Sing...

Regard,

Xiaoxin Sheng

[Alejanito]

This is the Build Visual Panel

[FreemanZ]

try to remove the year hierrarchy from the columns field of the Matrix Visual.

[Alejanito]

It does not make any difference. thanks

[FreemanZ]

remove the year, keep the columns field empty