How to make Matrix Visual dynamic

[murthyyyyy]

Hi All,

I am trying to achieve dynamic matrix visual as attached so I want to have 2 columns headers from column values from jira id and month column so first I have to pivot jira id column first and apply values from ‘Values column ‘ to it then I have to pivot month column and apply values form ‘Results‘ column how to do this in matrix visual ? I tried doing this in transform Tab I achieved the below expectable outcome and also I used table visual to showcase the values but when I do refresh the values in column jira I’d and month may change the same column headers will not be there How to make this dynamic ? Can some please assist?

Expected output
Name	Raised by	JIRA-7820	JIRA-7420	sep	sep
issue1	abc	-	6		0
issue2	xyz	6.5	-	9.2

Actual table
Name	Raised by	values	Jira id	results	Month
issue1	abc	6.5	JIRA-7820	9.2	sep
issue2	xyz	6	JIRA-7420	0	sep

But i get pivot like below, i dont want to expand any rows and columns, just i would like to get as table.

 Column Labels          JIRA-7420 JIRA-7420 Sum of values2JIRA-7420 Sum of resultsJIRA-7820 JIRA-7820 Sum of values2JIRA-7820 Sum of resultsTotal Sum of values2Total Sum of results sep   sep     Row LabelsSum of values2Sum of results  Sum of values2Sum of results    issue1    6.59.26.59.26.59.2issue26060    60Grand Total60606.59.26.59.212.59.2

Pivot Table
abc					6.5	9.2	6.5	9.2	6.5	9.2
xyz	6	0	6	0					6	0

Here is the snippte, i would like to achieve as simple table,

[danextian]

Hi @murthyyyyy ,

To accomplish your goal, you'll need some advanced DAX/PQ skills (depending on the chosen approach). Essentially, you must create a table with a column encompassing all required values for the matrix visual's column tile . As you aim to have the month name repeated based on the visible issue count, it's necessary to append space(s) after each month string. Please refer to the provided sample pbix for a starting point.

[Greg_Deckler]

@murthyyyyy Maybe The New Hotness? The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community