Skip to main content
Microsoft Idea

Power BI

Needs Votes

Exporting data from Matrix control is not including all of the underlying data.

Vote (9) Share
Manny Perez's profile image

Manny Perez on 11 Apr 2017 21:02:38

Exporting data from Matrix control is not including all of the underlying data for that result set. I have year, month, and week as slicer controls for the report but when I export to Excel from the Matrix control it only includes the year.

In the Matrix control I am only displaying year which is fine for the aggregated data and Summarized export, but when I select the underlying data it should include either the actual transaction/delivery date or at least the year, month, and week. Otherwise, you do not know which month and week are associated which each record.