Forum Discussion

TK202_BI's avatar
TK202_BI
Frequent Visitor
8 years ago

How to export crosstab data to Excel?

I see there's only options for exporting summarized data or underlying data, but didn't see anyway to choose export as crosstab. Dose anyone know if that's available? Thanks in advance.

Need Help

2 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    8 years ago

    TK202_BI,

     

    What do you mean by "crosstab data"? Currently, there are only those two options when exporting data to Excel. If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
    https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

    Thank you for your understanding.

     

    Regards,

    Charlie Liao

    • TK202_BI's avatar
      TK202_BI
      Frequent Visitor
      8 years ago

      Hi v-caliao-msft, thanks for your reply. By crosstab, I mean something in the screenshot below.

       

      For now, I can only export the data like this:

       

      Any idea if that's something available now?