Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 , 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..?
Ok it's a known issue :
I think that I should think about a new way to display my data.
Thanks for your help anyway.
User | Count |
---|---|
107 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |