Forum Discussion
Anonymous
6 years agoNot applicable
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?
1 Reply
- amitchandak
Super User
Anonymous , refer if this can help
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data