topic Re: Convert columns(having measures) to rows in DAX Commands and Tips

Convert columns(having measures) to rows

Anonymous — Mon, 21 Feb 2022 13:34:27 GMT

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.

Re: Convert columns(having measures) to rows

amitchandak — Tue, 22 Feb 2022 03:08:44 GMT

Anonymous , On power bi service, you have an option for Data with Current Layout. Is that not working for you?

Re: Convert columns(having measures) to rows

Anonymous — Tue, 22 Feb 2022 08:14:04 GMT

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.

Re: Convert columns(having measures) to rows

Anonymous — Thu, 24 Feb 2022 16:51:22 GMT

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