Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
104 | |
79 | |
68 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |