Sorting a matrix visual using numbers formatted as text

[Anonymous]

I need to sort this matrix by the column values in numerical order.  In the query, I have added a sorting column, but can't figure out how to sort in the visual.  

Matrix that needs sorting and the query I am using

[AnthonyTilley · Accepted solution]

in Desktop Click on your colunm in the fields list and then select Modeling at the top

in modeling click on sort by colunm and select your chronological colunm

Your field will now sort based on this filed instead

[Anonymous]

Anthony, thank you.   When I do that, i think, I do not see any drop down for sort.  Here is what I am doing:

From the Fields list, I select the column from my table that has the Age Category in it, which is a calculated column based on a range in a separate table

Age Category =

CALCULATE (

    VALUES ( 'Age Category'[Age Category] ),

    FILTER (

        'Age Category',

        'ServiceNow Tasks'[Age of ticket] >= 'Age Category'[Min]

        && 'ServiceNow Tasks'[Age of ticket] < 'Age Category'[Max]

    )

)

When I try the Sort by Column option, I see all the fields. So, I try to add the Age Category from the reference file above, the visualization breaks. I have tried to create a relationship between the reference table and the data tabvle, but returns a ISNUMBER error.

I am sure I am making a simple new user mistake, but I am totally lost.

[AnthonyTilley]

In your screen grap you showed a table that had 4 colunms in of Age,Max,min and Chronological

When applying the sort click the age colunm in this table and then in modeling>sort by select your chronological colunm. you should not need to refrence another table if you are using the same table as in your screen grab

Can you share a PBIX file or a screen grap of yor relationship model and i can take a look 

[Anonymous]

Dumb question - How do I share the pbix with you?

[v-frfei-msft]

Hi @Anonymous ,

Please upload your files to One Drive and share the link here.

[Anonymous]

Yes.  I will steralize my data and share.  Thank you so much for taking your time to help me out!

[AnthonyTilley]

You can not create a relationship because you are already referancing this field to create the field you would use to join. 

instead us a calculated colunm lookup value to bring in your chronological filed to your ServiceNow Tasks

Column  = LOOKUPVALUE('Age Category'[Chronoligical],'Age Category'[Age Category],'ServiceNow Tasks'[Age Category])

once you have this colunm in your service table then you should be abel to follow the steps in my previous post and sort the age catagory by this colunm.