Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to export matrix with Values as rows to Excel or CSV?

In my Power BI report, I have a matrix with StaffID, Month, and two measures, Sales and Returns. I want the users to be able to export the data in the following format:

 

 

 

But everything I have tried ends up with the exported file having Sales and Revenue as column headers, which I don't want.
How can this be done?