Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Export data underlying data not available

I am having an issue, the below report is not exporting any underlying data as shown below. There is no underlying data coming over in the Gross Margin Performance Current vs. Previous. 

 

Below is my power bi report 

 

 

There is no underlying data coming over in the Gross Margin Performance Current vs. Previous when I try to export the data in Power BI service. 

 

 

Please help me solve the issue, thanks 

 

Bhavesh

 

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I used Clustered Column chart with Report month as Axis, (Order entry, Updated OEC, Curr OEC) as Legend and one calculated column (Value_GrossProfit_$ / Value_Sales_$ =
    DIVIDE(SUM('GPM'[Value_GrossProfit_$]), SUM('GPM'[Value_Sales_$])) * 100) as Value. 

     

    I think the reason is, for using a calculated column in the visual I am not getting any underlying data when export. 

     

    How to resolve this problem? Help needed, thanks.

     

    Bhavesh

    • apollo89's avatar
      apollo89
      Helper II
      8 years ago

      Hi Bhaveshvp,

       

      I am facing a similar problem. Did you find any solution?

       

      Thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        apollo89, not yet. Open issue for me.