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.
I have a requirement where I need to have a matrix with 6 dimensions on rows, but only showing the sub-total at level 3 (this is for formatting purposes/requirements), with the Month-->Week on Columns. I need to be able to show the Column grand total, i.e. just the total for whole year, but without showing the subtotals for every month in between. I need to preserve the grouping format of Month--> Week on columns. Does anyone know a way to achieve this? I need to use the matrix, as I need to have the row and column groupings so a plain table is out. I found this thread:
https://community.powerbi.com/t5/Desktop/show-grand-totals-top-bottom-of-matrix/td-p/370909
But I was hoping that since then someone has figured out a good solution for this. Thanks!
Solved! Go to Solution.
Hi, @Anonymous
I'd like to suggest you refer the following link. Hope it helps.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
I'd like to suggest you refer the following link. Hope it helps.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ok, it looks like the confusion was mine - when I was originally setting this up, I couldn't find the "per column level" under sub-totals. Once I set this up, and set it only at the top level the grand totals are displaying at the end. Thanks All!
HI - Thanks for the response, I saw this post as well, but it had to do with Row Sub Totals not Column sub-totals. I've already done the row-by-row sliders to achieve the formatting I need. Unless you meant the other part about creating additional measures? Would this work for the columns then, instead of the rows?
See if this helps: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |