Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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)   ...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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