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 everyone
I've made a Matrice report but somehow this one has two columns with totals. I think one is enough for me.
I've looking with others and don't know how to disable it. I just need one column. Can you help? I've attach an example.
Many thanks
Pedro
I've made a Matrice report but somehow this one has two columns with totals. I think one is enough for me.
I've looking with others and don't know how to disable it. I just need one column.
This is by design. One of the two totals is Grand Total, and the other is Sub Total as shown below.
It is not possible to disable/enable Sub Totals for columns within Matrix currently. Please vote the following ideas:
In addition, similar threads below are for your reference:
https://community.powerbi.com/t5/Desktop/Controlling-subtotals-in-a-Matrix/td-p/30984
Regards
@pedroccamara I was able to reproduce the issue when I had multiple Fields in the "Columns" section... In these instances, the "Total Column" under "General" is the only formatting option which works, and in that case removes both totals, and the subtotal and grand total formatting options do nothing... I don't know if that is by design or not... Doesn't seem like it should be.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |