Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
67 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |