Forum Discussion
Sorting a matrix visual using numbers formatted as text
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
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
7 Replies
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
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.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