Custom sort Matrix

[1Haverhill]

I have tried a number of times to get a row to custom sort in a matrix. I tried setting up and importing a table and I added a conditional column to my master table. I cannot get the Matrix to sort based on the order I have given it. The Sort Fields button when it is visible does not do anything and the Sort Option does not show the added field.

Anny suggestions?

Time  TimeOrder

CumYTDTY	1
CumYTDLY	2
CumYTDLLY	3
Rolling12TY	4
Rolling12LY	5
LY	6
LLY	7
CurrPerTY	8
CurrPerLY	9
CurrPerLLY	10

[v-viig · Accepted solution]

Not related to Custom Visuals. Please post a new topic here.

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

[1Haverhill]

Ok Thanks I will research some more. I am using a matrix. I have Time descriptions in the Row. I would like to Sort them in an order other than alphabetical.

[1Haverhill]

I simply added a letter to the start of the text. A thru J. Not ideal but cannot spend hours on it.