Export summarized data at visual level workaround

[jja]

Hi Guys

I have a standart matrix table that shows sales by year,month,day(drill down enabled)

IF i want to export only sales by Month anyway it exports all the underlying data like year, month, and date and i know this is not possible to achieve this with matrix. I have a lot of visuals like it

What is your workaround on this? (non proposing to make pagination for these cases)

is the best option to create bookmark lets say "month" and instead of matrix add a table with only sales by month level and only then export data?

for me it looks like powerbi and excel are from same applications family but export to excel is really poor designed

[v-cazheng-msft · Accepted solution]

Hi, @jja 

If you want to export data by Month, you can remove Day level from the visual or create a visual only with sales by Month level. There is no way to directly choose to export data by Month level.

Best Regards,

Caiyun Zheng

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