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 ‘MR ‘ 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?

[PijushRoy]

HI @murthyyyyy 

Can you please share sample data (in excel format)
and expected outcome in matrix visual

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Thanks
Pijush