Column Grouping in Matrix Visual

Question

Hello all!&nbsp;I was wondering if the following can be achieved in PowerBI:&nbsp;I currently have a matrix that looks like this.&nbsp; As you can see, I had to create a different measure for every column.&nbsp;&nbsp;I want to achieve something like the following:&nbsp;Prior Week&nbsp;Prior WeekMTD&nbsp;MTD&nbsp;MTD&nbsp;MTD&nbsp;MTD&nbsp;MTDYTD&nbsp;YTD&nbsp;YTD&nbsp;YTD&nbsp;YTD&nbsp;YTDRev# of Deals2023#2022#2021#2023#2022#2021#&nbsp; 100,00010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,00010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,00010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,00010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,00010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,00010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100,00010&nbsp; 200,00020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200,00020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200,00020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200,00020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200,00020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200,00020&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 200,00020&nbsp; 300,00030&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300,00030&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300,00030&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300,00030&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300,00030&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300,00030&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 300,00030&nbsp; 400,00040&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400,00040&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400,00040&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400,00040&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400,00040&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400,00040&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 400,00040&nbsp;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.&nbsp;&nbsp;Appreciate your help!

amitchandak · Accepted Answer

omarluna17 , You have to try column header grouping in the calculation group or use the dynamic segment 
&nbsp;
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display: https://youtu.be/qMNv67P8Go0 
&nbsp;
column header grouping https://www.daxpatterns.com/dynamic-segmentation/https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795

Forum Discussion

Column Grouping in Matrix Visual

2 Replies

Related content

Matrix column not grouped

Grouping columns in Matrix

Grouping rows by Column and then updating Column

Create columns group

Grouping Columns

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