Matrix colum headers out of order

[coliveira2001]

Hi there, I'm trying to sort the column headers below in alphabetical order:

A, B, C comes from one table that has a relationship with the table where the values come from.

Ideas?

Thanks.

Thanks.

[v-yangliu-msft]

Hi  @coliveira2001 ,

I created some data:

Here are the steps you can follow：

1. Enter data – create a table.

2. Create a relationship from [Group] of the two tables.

3. Select [Group] – Column tools – Sort by column – [Index]

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[coliveira2001]

@v-yangliu-msft, thanks a lot for your response. I've manged to reproduced it the way you propose and it works. But I forgot to mention in the original post (sorry for that) that I have no fields in the rows. I just want the totals. My work around so far was to "hide" the first colum so I don't see the row headers. It displays only the totals in the solution you've presented.

[themistoklis]

@coliveira2001 

Try sorting the A,B,C values from the relevant table in Alphabetical order using Power Query and check again