Matrix Export to excel when "show values on rows" is turned on.

[sdeshpande1]

When a matrix power BI visual is exported which has "show values on rows" feature turned on then the export in excel doesn't the honor the layout in the visual using: Data with current Layout or Summarized Data option.

The workaround this is very tedious and is not a natural/seamless solution experience from a user perspective.

[sdeshpande1]

Correction

"show values on rows" should have been "Switch values to rows"