How to export crosstab data to Excel?

[TK202_BI]

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.

[v-caliao-msft]

@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]

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?