Skip to main content

Power BI

New

Export matrix report with specific format as it appears in PBI service

Vote (4) Share
Sumer Singh's profile image

Sumer Singh on 29 Jul 2024 14:01:30

Hi Team,


There are 2 scenarios I want to purpose here,


First: Currently when we have single measure on the Matrix report in PBI service, measure name is hidden. But when we export the data from the report, then the column header of the measure starts appearing in the exported file.

Second: with single measure on the Matrix report in PBI service it appears like a normal tabular report. So when we export this report, it should appear in the same format as a tabular report.


End users don't know if we have created the visual as a matrix or tabular report in this case, so they want it in the same format as it appears in PBI service.


Proposed solution: There should be an option to select the format of the exported file at report level by the developer. If they want the export in tabular format or matrix format in case of single measure. And other option if they want to show the measure header in the exported report or not.

(For multiple measures this can be disabled and only option is to export it as Matrix report).