matrice report with 2 total columns

[pedroccamara]

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

[v-ljerr-msft]

@pedroccamara

---

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:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13185840-please-provide-a-way-to-...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9325119-please-provide-way-to-rem...

In addition, similar threads below are for your reference:

https://community.powerbi.com/t5/Desktop/how-get-Grand-Total-on-Matrix-Visualization-without-the-row...

https://community.powerbi.com/t5/Desktop/Controlling-subtotals-in-a-Matrix/td-p/30984

Regards

[Seth_C_Bauer]

@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.