Hybrid Table - Matrix and Table together

[amit3]

Hybrid Table - To have a table which is a Mix of table and matrix. Simple table Can be at the start or at the end

[fbcideas_migusr]

Link to screen shot https://www.dropbox.com/s/1fwr50wixywgwvk/Screenshot%202020-02-25%2022.43.35.png?dl=0

[fbcideas_migusr]

I know the concept as a row & column area, in which e.g. multiple column areas with different column filters can be defined.

[pbiideas1]

I am struggeling with this also

[deepu2108]

This is a feature I have seen multiple clients requesting for while working in different domains..

[fbcideas_migusr]

I have a project where this would be perfect. We are implementing this in Excel using a Power Pivot table, and then a series of complex dynamic array formulas, but it is less than ideal. Would love to see this visual implemented, or functionality added to the existing Matrix visual.

[henning_steinba]

That would be a great improvement - what we need is basically the same thing as the Tablix in SSRS

[Sophia1]

An example use case here: https://community.powerbi.com/t5/Desktop/Matrix-with-mix-of-measures-in-rows-and-columns-Recreate-Excel/m-p/1719454#M679748

[Mircea_rusu]

Tableau allows these kind of tables, please implement this in Power BI

[denglish]

This should really be an option given SSRS has done this for years via tablix.

There must be a technical reason behind it's omission, but it's driving me nuts. I can't get buy-in for Power BI from senior management, as when they ask for the most simple example reports (e.g. 6 months trend with YTD and budget for current month/current YTD only), I can't deliver them. 

It's a major reason I can't migrate to Power BI. From a financial presentation perspective, this product is so hard to work with at the moment.

 

[fbcideas_migusr]

Yep a simple companion matrix option would also do the trick , add the companion visual next to the main matrix and it operates like a matrix but uses the rows from the main visual. Should be easy and would be extremely flexible