export with summary row

[lfil]

Hello all,

could you help me how can I export table from service to excel with the summary row?

Thank you, Lucy

[v-shex-msft · Accepted solution]

HI @lfil ,

You can export summarize records on power bi service, but it is impossible to export with the total row that power bi visual created.

Export the data that was used to create a visualization 

In my opinion, I'd like to suggest you create a calculated table to add summary total rows, then you can export the underlying data from this table to achieve your requirement.

SUMMARIZE 

Regards,

Xiaoxin heng

[lfil]

Thank you 🙂🤗

[Anand24]

Hi @lfil ,

I'm afraid but this feature is still not available in Power BI.

This much needed feature has been provided as an idea to Power BI and you vote for it. Link

As an alternative(not something you would like but is the only option right now), you can manually calculate the total in excel using excel formulae.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!