Forum Discussion
Solved
Sort matrix column header
I have a matrix column with headings Annual, Month, MTD, YTD. I want to sort them in custom order. Please can someone help. Thank you.
bml123 Create your sort column in Power Query to avoid DAX circular dependency errors.
bml123 , to Avoid That
Assum col is your main column
Col1 = col
Col Sort = <Logic>
Sort Col1 on Col Sort and Use Col1 in your UI. You can Hide Col.
I followed your steps exactly and still getting circular dependency error. Please can you help.
bml123 Create your sort column in Power Query to avoid DAX circular dependency errors.