Combine a table and a matrix into one table viz

[raymondpocher]

Hello Community,

I have once again a requirement from my stakeholders that I just dont know how to deal with. It is a combination of a table and matrix table. I can see the added value of such a visualization. I see that there is no way to do that in power bi. Do you happen to have an idea anyway?

Hier is an example of the wanted output:

Wanted Output

This is how the input sort of looks like.

Example of the input

[raymondpocher]

Thanks everyone!

@amitchandak  I have found your solution link to be best. Yet it is a pretty time consuming process. It would be great if Power BI integrates that as a standard. So I have voted for it. 

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1... 

If you holy power bi are reading this, please add it as a new feature soon!

[mahoneypat]

Please see this article (the 2nd part on Calculations Groups) for how to do this.

Building a Matrix with Asymmetrical Columns and Rows in Power BI - Excelerator BI

Pat

[amitchandak · Accepted solution]

@raymondpocher , You need a hybrid table, which is not supported as of now

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/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

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