Normalize and De-normalize Matrix data

[Anonymous]

Hi,

Is it possible to create matrix like this in power BI Desktop?

where RVP, Sales Rep and CSM are one field's data: (Sales Person Role Group)

and Names are another field: (Sales Person Name)

We want to see the User belongs to which Group with Region and show the Opportunity $ amount. 

Thank you

[Anonymous · Accepted solution]

Hi @Anonymous ,

I have built a data sample:

Please disable the "Stepped layout" and "Row subtotals", and based on my knowledge, through it's a little diffenent from what you expected,we could only do this currently.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You need to unpivot the three-column RVP, Sales Rep and CSM  in power query for that

Or how can you check for matrix table work around 

if you are looking for a Hybrid display with Matrix Column and measure
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc