topic Re: Export Dynamic Data Labels to Excel in Developer

Export Dynamic Data Labels to Excel

AlwaysBI — Fri, 14 Jul 2023 00:31:55 GMT

Dear support community,

The percentage shown in this chart is Dynamic Data Labels created by Power BI. When user export the data to Excel the percentage data doesn't export. Is there anyway we can export it?

Thank you.

BiDev.

Re: Export Dynamic Data Labels to Excel

Anonymous — Mon, 17 Jul 2023 02:57:11 GMT

Hi @AlwaysBI ,

I created a sample pbix file(see the attachment), it can export the field with the percentage. How did you set your chart? Could you please provide some raw data in your tables(exclude sensitive data) with Text format and the Fields settings of your visual. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

Export visual data

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

Re: Export Dynamic Data Labels to Excel

AlwaysBI — Mon, 17 Jul 2023 09:21:15 GMT

This is a sample of exported data we have.

Basically our data is the exact number instead of percentage, but in BI dashboard, we have the percentage as data labels, we wanted to get the data label percentage as well as the exact number exported if possible.

Re: Export Dynamic Data Labels to Excel

Anonymous — Thu, 20 Jul 2023 06:47:45 GMT

Hi @AlwaysBI ,

According to your description, you are actually using the field 'Target' with the aggregation(SUM) on the Y-axis. But you are using 100% stacked column chart, and you want to export the data with the percentage values as well. However this is not possible...

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

You can do what I did in the pbix file in my previous reply, change the visual type to stacked column chart and create a measure to get the percentage. Then put it on the Y axis to replace the original field (SUM('Table'[Target]))...

percentage = VAR _location = SELECTEDVALUE ( 'Table'[Location] ) VAR _sumtarget = CALCULATE ( SUM ( 'Table'[Target] ), FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Location] = _location ) ) RETURN DIVIDE ( SUM ( 'Table'[Target] ), _sumtarget )

Best Regards