Custom arrange the multiple column headers in matrix view

[Anonymous]

Hi,

I have column header as shown below in figure. There are three columns on top mainly Period, TYLY and then Value i.e. numbers. Period is first level header, TYLY is second level header.  I want to put week 12, TY, Value combination first then week12, LY and its YoY afterwards, Week 11 LY, and MTD, TY, Comp MTD, LY combination next and then YoY finally. How I can go about that? 

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

If you want to put it in a custom order, you can try to customize the index yourself. For example, you can create a conditional column in Power Query Editor.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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