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.
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
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |