Power BI Matrix Export to excel

[Annemie19]

Hi There,

I have a matrix setup in Power bi. The problem is the users need to export it to excel for formatting but when exporting the columns and rows are switched around. 

This is what the matrix looks like in Power BI:

But when I export to excel it looks like this:

As you can see the ValueDate_month and year are all now columns. How can I export this to show correctly?

Kind Regards, 

[Anonymous]

Hi there,

I got the same query from our users and hardluck cannot find the solution yet.

@MattAllington --> is there any other workaround/solution, please advise...

Thanks.

MAK.

[amitchandak]

@Annemie19 , I think it is typically data export not the formatted data export. You can try the tool suggested by @PaulDBrown .

[PaulDBrown]

@Annemie19 

You mght want to try out the free tool provided by the gurus at sqlbi.com

https://www.sqlbi.com/tools/analyze-in-excel-for-power-bi-desktop/ 

[Annemie19]

Thanks a lot Paul, 

The users are exporting from the browser app. 

Is there no such solution for this?

[v-kelly-msft · Accepted solution]

Hi  @Annemie19 ，

Check the similar thread below:

https://community.powerbi.com/t5/Desktop/I-want-Export-data-of-matrix-visual-in-matrix-form-not-in/t...

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!