Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Convert columns(having measures) to rows

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.

3 Replies