How to Remove the "Total"

[Anonymous]

Hi:

Earlier today, I had asked how to remove the "Total" from a Power BI report.  I was told to click the format button for the visual and I would find the mechanism to turn off the total.

I do not see that "mechanism", as I call it.

Where is it, if not in the formatting section?

Thanks!

John

[v-xuding-msft]

Hi @Anonymous ,

As camargos88 shares, you could remove it in Total of the Format field directly.

And you could reference the blog to learn other cases.

https://radacad.com/removing-the-total-value-for-a-column-in-the-table-visual-of-power-bi-using-isfiltered

[camargos88]

[Anonymous]

Thanks, for the replies!!!

Unfortunately, I don't see that in my install of Power BI Desktop.

John

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

Do you install the latest version of Power BI Desktop (2.79.5768.721)?  And which visual do you use? Can you please share a few screenshots of your situation?