Matrix visual with groupings and totals

[ToyotaYaris]

Hello,

I want to create a matrix (or table) visual with groupings and totals in PowerBI Pro. I tried many things with the standard matrix visual in PowerBI, but it seems like it's not possible to create what I want. I think it's possible in SSRS or with paginated reports, but my client does not want to use SSRS. 

I created a simplified version of what I want to achieve in Excel: 

Any help would be much appreciated! Thanks in advance. 

[v-robertq-msft]

Hi, @ToyotaYaris 

According to your picture, I think the only way to get the result in Power BI is to create a Matrix for each group of ID/name, which is very complex and takes a lot of time to achieve. You can go to the Excel community to ask for methods in Excel. Here’s a case that requires a similar result as yours:

https://community.powerbi.com/t5/Desktop/Totals-only-for-some-columns/td-p/1551632

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ToyotaYaris]

There is no workaround to achieve something that is comparable with what I want? Just the groupings based on customers (name/id) would help a lot! 

[ToyotaYaris]

Unfortunatley paginated reports are only available with a premiun license, my client only has pro licenses. Is there any other way to achieve something similair? 

[amitchandak]

@ToyotaYaris , difficult to have in power bi matrix - https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

You can check power bi paginated report - https://docs.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-faq