Change columns in Array

[Syndicate_Admin]

Hello friends I have a situation I have a report with a matrix in which it shows sales information per year, all good with the information but they ask me to make a change that I have not been able to find and so that they understand me better attached an image of how the Power BI Desktop shows me

and what they ask me is that it be shown as follows, this is in an excel

I hope you can help me with this issue.

Thanking you for your help

Best regards

[amitchandak · Accepted solution]

@Syndicate_Admin , do you want measure on top ?

You can try calculation group

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

or refer

column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795