Forum Discussion
Export data from a visual with additional fields not shown in the chart
Hi everyone,
I have a line/column chart where:
- X-axis: Month
- Y-axis: A measure (e.g., Sales, Revenue, Quantity)
The business has requested that when they Export Data from this visual to Excel, they should see something like:
Month Product Measure Jan ProductA 100 Jan ProductB 200 Feb ProductA 500 .. .. ..
- If Product is added to the Tooltip, will it be included in the exported data?
- If Product is added as the next level in the Axis hierarchy (but the visual remains drilled up to Month), will it be included in the export?
- Is there any supported way to export additional columns that are not displayed in the visual, while keeping the visual itself unchanged?
AnkitaaMishra Please ensure to select below options when exporting data from the visual in PBI Service -
Export data > Summarized data > .xlsx (Excel only) / .csv options
If User wants live connection to the data, can use 1st option as well.
Checkout below examples -
1. Tooltip - Product added in Tooltip
2. Axis level Hierarchy - Product added in X-axis, but not drilled upto Product.
💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer
5 Replies
Hi AnkitaaMishra, Check below solutions for your questions -
1. Product field included in Tooltip will be included in the exported data.
2. Product field included in next level in the Axis will be included in the exported data even if its not drilled to Product level.
3. Either the field should be added in Tooltip or used in the visualization to capture in the exported data.
💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics EngineerAnkitaaMishra Checkout below examples -
1. Tooltip - Product added in Tooltip
Export -
2. Axis level Hierarchy - Product added in X-axis, but not drilled upto Product.
Export -
💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer
Hi Rupa01 , thanks for the reply!
I can see that the export includes the Product column when I test it in Power BI Desktop. However, when I export the same visual from the Power BI Service, I don't see the Product-level details in the exported file. Is there a setting or configuration in the Service that I might be missing? Thanks!AnkitaaMishra Please ensure to select below options when exporting data from the visual in PBI Service -
Export data > Summarized data > .xlsx (Excel only) / .csv options
If User wants live connection to the data, can use 1st option as well.
Checkout below examples -
1. Tooltip - Product added in Tooltip
2. Axis level Hierarchy - Product added in X-axis, but not drilled upto Product.
💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics EngineerThanks! I was selecting the Live connection option, which was resulting in a blank export.
