Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
@Anonymous , refer if this can help
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 63 | |
| 45 | |
| 41 | |
| 36 | |
| 23 |
| User | Count |
|---|---|
| 189 | |
| 124 | |
| 106 | |
| 78 | |
| 52 |