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!View all the Fabric Data Days sessions on demand. View schedule
Hi folks,
I have matrix table as shown below but I am not able to download it in excel in same format as I have selected "Show on Rows" option to get the below format. All volume data are measures and Organizational unit and months are table columns. Is there any dax query or any other way so that we can download the matrix view like below .
If I turn off "Show on rows" report will become like below:
Thanks in advance.
Solved! Go to Solution.
Got the solution and its working as expected.Followed below link:
https://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/
Thanks
Got the solution and its working as expected.Followed below link:
https://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/
Thanks
No it's not working as I have to turn on "Show on rows" option to get my format. Due to that I am not able to export in same format.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 13 | |
| 11 | |
| 9 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 28 | |
| 20 | |
| 20 | |
| 19 | |
| 12 |