Matrix Column mangement

[PierreL69]

Hi there,

I have a small and simple question (I think) about column management in a Matrix visual

Below are the data I have added to my visual 

Rows:

- Range

- Product

Columns:

- Year

Values :

- Quantity

- Sales

Below this is the Matrix I have in PBI

Initial Matrix

But I would like to get is this :

Wanted result

However I can't get this visual and I don't know how to do it.
Does anyone have a simple idea?

Thanks a lot,

Kind regards

[amitchandak · Accepted solution]

@PierreL69 , the second screenshot means the measure is above and the year is below

You can do that using calculation group

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0

[PierreL69]

Do you have maybe something less complex and more focused on what I am trying to do ?

I am trying to find a solution on google but wihtout success 😞

Thanks

[PierreL69]

Ouch seems complicated I thought there was something simple

I'll try to digest this video, to try to come up with something