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.
Hello,
i made very simple table - Region, Restaurant number, Restaurant adress and Revenue but when i add adress i see subtotals for every adress and it looks like double information. How i can hide subtotals for one dimension in Matrix?
I don't know why but don't have "Total row" in Subtotal menu. My version of Power BI 2.46.4732.721 May 2017
Which matrix are you using?
I'm using the fancy new Preview matrix that you need to turn on in the settings.
Hi @AlexKamaev,
Based on my test, the 'Total Row' option in Subtotal menu is for the new Matrix Preview visual, and this option is in General menu for the current Matrix visual. Setting it off will turn off all Totals(including sub total and Grand total), so it may be not the right solution here, and it seems no better solution currently.
Here is a similar idea about ablility to select sub totals for the matrix shared on Power BI Ideas. You can vote it up and add your comments there to improve Power BI on this feature.
Regards
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |