Skip to main content
Microsoft Idea

Power BI

Needs Votes

Download an Excel file in Matrix Format (not normalized)

Vote (45) Share
's profile image

on 03 Apr 2017 22:13:18

So I have a matrix table setup, works fine. But when I have my users download the matrix as an Excel file, the downloaded data is no longer presented in the same way as the matrix.

The data has been normalized, which means the users will have to re-create the matrix via a pivot table.

It would be really slick if Microsoft did both on download, create a sheet with the raw data (normalized) and created a second worksheet with the original matrix visualization as a pivot table.

But if that's too much, just having a plain table in the original matrix format would suffice.

Comments (3)
's profile image Profile Picture

Andreu fil on 19 Apr 2024 15:03:21

RE: Download an Excel file in Matrix Format (not normalized)

Good information, thankssehackear.top

's profile image Profile Picture

Kevin L on 05 Jul 2020 23:29:05

RE: Download an Excel file in Matrix Format (not normalized)

Needed !

's profile image Profile Picture

Mark Walter on 05 Jul 2020 23:03:39

RE: Download an Excel file in Matrix Format (not normalized)

I would also add that from a user standpoint it would be nice for them to be able to also print a matrix table from the service, in a report format, and get multi pages if necessary.