Forum Discussion

bhavsarravi's avatar
bhavsarravi
Frequent Visitor
7 years ago
Solved

While exporting summary data for Line and Stacked Column chart , the exported header text has issue.

Using Line and Stacked Column chart , the exported summary data from embedding report has naming issue for header text.

It is particularly for the Line Values field text.

 

Steps to reproduce the issue:

  1. Create a report, having visual using Line and Stacked Column chart. Create this chart having Line Values field and rename it with some text, other than field name.
  2. Publish the report to Power BI service.
  3. Open report in Power Bi service.
  4. Export Summarized data from the Line and Stacked Column chart.
  5. Exported excel report header text for Line Values column will be miss-matched.

Note: I have also tested this issue in Sample Application and Power BI service, where it is reproducable.

 

Please assist with this issue as soon as possible.

  • Thank you. I was able to resolve this issue by deleting the Line value field and recreating it the same.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    bhavsarravi,

    Do you use Power  BI Desktop October release(2.63.3272.40461)? I repeat your steps in my Power BI Report and export data to Excel from the  Line and Stacked Column chart, the header name of Line matched that in Power BI Service.

    Could you please share a PBIX file containing dummy data which I can reproduce?

    Regards,
    Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable

    bhavsarravi,

    Yes. I checked the columns in exported Excel and compare them to Power BI Service.

    Regards,
    Lydia

  • bhavsarravi's avatar
    bhavsarravi
    Frequent Visitor

    Thank you. I was able to resolve this issue by deleting the Line value field and recreating it the same.