Visualization - Export Data options output to Summarized Data or Underlying data are swapped.

[clmsambo]

It seems the Export Data option for Visualization has the functionality swapped.    I have a Pie chart with totals,  select Export Data and choose "Summarized Data"  the results are the detail values for each color segment in the chart.    If you pick "Underlying data"  you get a summary total of the all the values in the chart.   I would expect the opposite.    Is this a bug or not?

[Anonymous]

Hi @clmsambo 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table or share me with your pbix file from your onedrive business.

Best Regards,

Rico Zhou

[Anonymous · Accepted solution]

Hi @clmsambo 

Due to I don’t know your detailed data and your data model.

I build a sample:

And the Pie visual is as below:

Then I publish it to Service and Export Summarized Data and Export Underlying Data.

Export Summarized Data:

Export Underlying Data:

Note: If your visualization has an aggregate, selecting Underlying data removes the aggregate. And if your visualization doesn’t have any aggregate such as Sum, Average, our Underlying data will be the same as Summarized data.

For more info : https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data

My test result is correct , please use my sample for a test.

If this still can’t help you to solve the problem, please provide me your pbix file.

You can download the pbix file form this link:

https://qiuyunus-my.sharepoint.com/:u:/g/personal/tongzhou_qiuyunus_onmicrosoft_com/EV0HT_WUc0dLjoBU...

Best Regards,

Rico Zhou

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