Unwanted total shows up when exporting to Excel

[MDekker]

Hi all,

This visual has totals enabled on Niveau 5 and Niveau 4. Disabled at Niveau3

When exporting to Excel, totals appear on Niveau 3 as well. How to suppress it?

i exported to excel using the first(default) option with exporting using the current layout

Any ideas? Bug?

[v-jiewu-msft · Accepted solution]

Hi @MDekker ,

Based on the testing, the total can not be seen in the exported file.

Trun off the totals in visual.

Then, export to file.

Besides, if enable the total, the total will be seen in the exported file.

You can also view the following document to learn more information.

Export data from a Power BI visualization - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.