Skip to main content

Power BI

New

Improved Summarized Excel Output from Matrix Visual - with totals for Level shown and appropriate labels

Vote (2) Share
Dominic Clarke's profile image

Dominic Clarke on 08 Nov 2021 16:11:00

When the user exports "summarized" data from a Matrix the xlsx output shows a row for all the levels of the rows in the Matrix regardless of whether the user has them displayed in the report.

It would be nice if the output from the Matrix could actually follow the same level as that shown, i.e. giving the value totals for that level (including a totals row if that is selected in the visual properties).

Additionally it would be beneficial if the headers used in the output would also use the "renamed for this visual" labels for the "Columns" and "Values" entities. Currently (in Oct 2021 release) only the specific labels are shown for the "Rows" entities.