Subtotal rows in a table

[Tybaal]

Hello all, 

do you think if there is a custom way to display subtotal rows in a table (not a matrix)?

Example:

I have this table of data:

And I would like to have subtotal rows for column "Quantity" by "ProductCat" like that:

I tried with the tools provided by Power BI but failed... And my client doesn't want a matrix view...

Can someone help me?

Thank you in advance

[Angith_Nair]

Hi @Tybaal ,

There is no option for subtotal in table visual in Power BI.

[amitchandak · Accepted solution]

@Tybaal , I doubt this format, But you can have subtotal in the Matrix. And also customize series to have a selective subtotal

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[Tybaal]

Hi @amitchandak , 

That was my fear....

I tried with a matrix but I have another issue. I have a lot of rows in my matrix (like 20) when it becomes wider than the screen, I need to scroll horizontally to see all the level. But the scroll concern only the values so I cannot see all my matrix...

Do you know if there is a way to say "scroll the entire matrix and not only the value"?

[Angith_Nair]

Could you please share the pbix file so that I can look into it..?

[Tybaal]

Ok it's a known issue :

https://community.powerbi.com/t5/Desktop/Matrix-not-allowing-horizontal-scroll-in-Power-BI-Desktop-o...

I think that I should think about a new way to display my data.

Thanks for your help anyway.