Forum Discussion
Normalize and De-normalize Matrix data
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
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.
2 Replies
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#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebcHi 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.
