Matrix Column Head Order

[Anonymous]

Is there a way to change the order of the column heads in a Matrix table.  Currently it displays in alphabetical ascending order.  I would like to reverse that if possible.  A prefered option would to be able to put it in a custom order.  Are either of these options available?

[Anonymous]

This solution is incorrect

[Anonymous]

Is there a way to implement this when in Direct Query mode? I had it working in import mode, but now the needs of my project have required direct queries

[S184019]

I don't think this exists as of yet.  I have been searching for a while. I even created my query to sort so that data would come into the query editor window in the proper chronologic order like this, 

  order by case when [Month] like '%Jan%' then 1
					   when [Month] like '%Feb%' then 2
					   when [Month] like '%Mar%' then 3
					   when [Month] like '%Apr%' then 4
					   when [Month] like '%May%' then 5
					   when [Month] like '%Jun%' then 6
					   when [Month] like '%Jul%' then 7
					   when [Month] like '%Aug%' then 8
					   when [Month] like '%Sep%' then 9
					   when [Month] like '%Oct%' then 10
					   when [Month] like '%Nov%' then 11
					   when [Month] like '%Dec%' then 12
					   end 

Still nada! If this isn't a suggestion for an improvement, I don't know what is. 

[Anonymous]

I solved it by sorting by another column that I called date order

[S184019]

@Anonymous

Hey I agree there are work arounds.  I solved it the same way.  Most things MS are Drag and Drop and I am hoping to usher that same motif into life here. 

Thank you for a great suggestion!  

[yatinpurohit]

Thanks. This worked out perfectly.

[Anonymous]

Thanks Herbert...this should help quite a bit!

Tim

[BhaveshPatel]

Hi There,

You can drag your column fields in matrix visuals up and down to see the expected result.

Thanks & Regards,

Bhavesh

[senthilaa]

Hi there,

can you please share some screenshot for this, thanks in advance

[Anonymous]

Bhavesh,

The columns are not seperate categories in different columns...as shown below they are retailers all contained in one data tables column.