Column Grouping in Matrix Visual

[omarluna17]

Hello all!

I was wondering if the following can be achieved in PowerBI:

I currently have a matrix that looks like this. 

 

As you can see, I had to create a different measure for every column. 

I want to achieve something like the following:

Prior Week	Prior Week	MTD	MTD	MTD	MTD	MTD	MTD	YTD	YTD	YTD	YTD	YTD	YTD
Rev	# of Deals	2023	#	2022	#	2021	#	2023	#	2022	#	2021	#
100,000	10	100,000	10	100,000	10	100,000	10	100,000	10	100,000	10	100,000	10
200,000	20	200,000	20	200,000	20	200,000	20	200,000	20	200,000	20	200,000	20
300,000	30	300,000	30	300,000	30	300,000	30	300,000	30	300,000	30	300,000	30
400,000	40	400,000	40	400,000	40	400,000	40	400,000	40	400,000	40	400,000	40

The rows would be cities and the columns would be grouped by Prior Week, MTD, and YTD. The second row is the revenue and deal count for every year. 

Appreciate your help!

[amitchandak · Accepted solution]

@omarluna17 , You have to try column header grouping in the calculation group or use the dynamic segment

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

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

[omarluna17]

Very informative and helpful video. Thank you for your help!