Export all the matrix column fields and subfield

[Anonymous]

Hi there,

I'm facing a problem with the export of a report data from PowerBI site to excel file. In particular I have a matrix in which I have 2 levels of column fields (see the image below). What I would like to do is to include in the export not only the "low level" fields, but also the top ones. When I export to xlsx, instead, it takes only the lower level column fields. I would like to have in the final excel file the same structure that there is the PowerBI report. Do you think this is possible? 

Report in PowerBI .comExport in Excel

[venal]

@Anonymous 

As i know that it is not possible, please vote for the idea for future release.

If you have any queries, please let us know.

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

BR

venal.

[v-eachen-msft]

Hi @Anonymous ,

I am afraid that Power BI doesn't support it currently.

You could use PowerPoint, PDF to export the matrix.

You could also vote for the following idea to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35167033-matrix-data-export-to-excel