How to make Matrix Visual dynamic

Question

Hi All,&nbsp;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&nbsp;&nbsp;&nbsp;&nbsp;NameRaised byJIRA-7820JIRA-7420sepsepissue1abc-6&nbsp;0issue2xyz6.5-9.2&nbsp;Actual table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;NameRaised byvaluesJira idresultsMonthissue1abc6.5JIRA-78209.2sepissue2xyz6JIRA-74200sep&nbsp;But i get pivot like below, i dont want to expand any rows and columns, just i would like to get as table.&nbsp;Column Labels&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;JIRA-7420&nbsp;JIRA-7420 Sum of values2JIRA-7420 Sum of resultsJIRA-7820&nbsp;JIRA-7820 Sum of values2JIRA-7820 Sum of resultsTotal Sum of values2Total Sum of results&nbsp;sep&nbsp;&nbsp;&nbsp;sep&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Row LabelsSum of values2Sum of results&nbsp;&nbsp;Sum of values2Sum of results&nbsp;&nbsp;&nbsp;&nbsp;issue1&nbsp;&nbsp;&nbsp;&nbsp;6.59.26.59.26.59.2issue26060&nbsp;&nbsp;&nbsp;&nbsp;60Grand Total60606.59.26.59.212.59.2 Pivot Table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;abc&nbsp;&nbsp;&nbsp;&nbsp;6.59.26.59.26.59.2xyz6060&nbsp;&nbsp;&nbsp;&nbsp;60&nbsp;&nbsp;&nbsp;Here is the snippte, i would like to achieve as simple table,

greg_deckler · Answer

murthyyyyy&nbsp;Maybe The New Hotness?&nbsp;The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community

danextian · Answer

Hi murthyyyyy ,
&nbsp;
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.

&nbsp;

Forum Discussion

How to make Matrix Visual dynamic

2 Replies

Related content

Matrix Visual Duality

Custom Matrix Visual

Power Matrix visual

Formatting Matrix Visuals

Matrix visual

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