Skip to main content
Microsoft Idea

Power BI

Needs Votes

Hybrid Table - Matrix and Table together

Vote (183) Share
Amit Chandak's profile image

Amit Chandak on 23 Feb 2020 00:22:54

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

Comments (15)
Amit Chandak's profile image Profile Picture

Giribabu Garigala on 06 Mar 2023 17:01:24

RE: Hybrid Table - Matrix and Table together

We should need this table, who are migrating reports from Qlik and Tableau

Amit Chandak's profile image Profile Picture

Chris Tunnicliffe on 27 Feb 2023 11:52:36

RE: Hybrid Table - Matrix and Table together

On the back of working on a project whereby I have had to create numerous measures to create my own bespoke matrix due to the limitations of the default matrix adding columns for every instance (e.g. a sparkline column being created for every single date in the matrix being a basic yet infuriating example), this hybrid table/matrix where you can choose what you want to show is sorely needed.

Amit Chandak's profile image Profile Picture

Jon Shinn on 03 Nov 2022 16:55:48

RE: Hybrid Table - Matrix and Table together

I run into this limitation all the time. Please please please add this!

Amit Chandak's profile image Profile Picture

Nicholas Kaiser on 21 Oct 2022 20:59:41

RE: Hybrid Table - Matrix and Table together

This feature desperately needs to be added, in the meantime I've had to use tabular editor to "hack" the results. . . Whereas it's a simple default feature in Tableau.

Amit Chandak's profile image Profile Picture

Abdulaziz nasaar on 10 Oct 2022 15:32:35

RE: Hybrid Table - Matrix and Table together

Hi,


I think this feature is really needed and it is currently can be achieved in SSRS quite easily.


For any financial reporting matrix reports this is a must and the work around is too time consuming.



Thanks

Amit Chandak's profile image Profile Picture

Terry HULL on 31 Aug 2022 07:26:59

RE: Hybrid Table - Matrix and Table together

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

Amit Chandak's profile image Profile Picture

David English on 26 Aug 2021 15:12:26

RE: Hybrid Table - Matrix and Table together

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.



 

Amit Chandak's profile image Profile Picture

Mircea RUSU on 23 Aug 2021 13:51:19

RE: Hybrid Table - Matrix and Table together

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

Amit Chandak's profile image Profile Picture

Sophia Turner on 12 Mar 2021 19:51:22

RE: Hybrid Table - Matrix and Table together

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

Amit Chandak's profile image Profile Picture

Henning Steinbach on 06 Nov 2020 13:37:27

RE: Hybrid Table - Matrix and Table together

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