Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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.
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |