Header column sorting in the matrix visualization

[VeronikaB]

Hello team,

could you please advise how to get the ordered quarters under the name of measures within one matrix visualization/table? There is only option to get Quarters into the 'Column' section & Units, Revenue, Margin measure into the 'Values' section in a basic view but customer wants to see the output(s) in a reverse version 

I only have live cube connection what causes limited option in modeling tab section.

What kind of dax measure combinations should I use to get this kind of view below? I have not found a specific solution so far.

 Units (measure)            | Revenue (measure)      | Margin (measure)

Q1  |  Q2   |  Q3  | Q4     |Q1  |  Q2   |  Q3  | Q4    |Q1  |  Q2   |  Q3  | Q4 |

Thank you for your help.

[v-diye-msft]

Hi @VeronikaB 

you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.

[amitchandak]

In matrix, you have the column above measure. I do not see the options to move below. Check for a custom table in market place. Also, check if there an idea for the same.

ideas.powerbi.com/