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.
Trying to figure out how to display row grand total only in a matrix visual that has three fields per row. Below screen shot shows subtotals for Week Start and LJ Department and Site. Is there a way to not display those subtotals and only display last row (i.e. Grand total)? There is a setting to turn Row Subtotals on or off. But there isn't a similar setting to turn on Row Grand Totals on or off
Hi @TomSinAA
Did the solution @Ritaf1983 provided hepl you solve the problem? if it helps, please consider to mark it as a solution, or you can offer more information.
Best Regards!
Yolo Zhu
Hi @TomSinAA
To have a grand total on and row subtotals off you need to switch off the row sub-totals of all hierarchies except of the highest.
For example, my matrix has 2 levels :
Category and age group :
So on age group, I'll switch off the row subtotal:
and on category switch on :
Result :
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
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 |
---|---|
103 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |