Forum Discussion

AnkitaaMishra's avatar
AnkitaaMishra
Super User
1 month ago
Solved

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 Exce...
  • Rupa01's avatar
    Rupa01
    1 month ago

    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