Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.
User | Count |
---|---|
96 | |
85 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
96 | |
96 | |
67 | |
59 |