Forum Discussion
Order text value using numeric values for a matrix visual to show most or less critical text value
What you need to do is use the Sort by Column icon under Column Tools.
You can either create a column in your data table and call it SortOrder or create a new Dimension table and create a relationship with your main table.
| Category | SortOrder |
| High | 3 |
| Medium | 2 |
| Low | 1 |
Now select the column in your main table, click on column tools, the click on Sort by Column and choose this new SortOrder column.
This should solve your issue.
Regards,
First of all, thanks for your answer.
I created a new table via "insert Data" (not sure if it's correct, i'm using the italian version of the application), insert my data (Baseline, Basline+, Baseline++ and 1,2,3). Linked category column with my cloud data criticality column in the table i need to associate values to.
BUT, when i click on "Sort By column" after selecting the correct column in main table, i can only choose between columns of the same table. There's no "SortOrder"column in the menu.
Is there something wrong in my procedure?
Also, maybe a stupid question: isn't this only gonna order my table rows based on the value i gave to my categories, instead of showing "Low" instead of "medium" in a matrix based on the value i chose?
(again, sorry for not being totally clear but language barrier + data science illiteracy are not a good match in this case)