Forum Discussion
Subtotal rows in a table
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
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
5 Replies
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
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"?
Could you please share the pbix file so that I can look into it..?
Hi Tybaal ,
There is no option for subtotal in table visual in Power BI.
