Data sorting in table matrices

[Tara_01]

Hi all,

I have a small query, I have two columns in a table visulaization column A & column B I have sorted the data in ascending order as per column A. However as we can see in the screenshot in the range 105 & 109 are not arranged in ascending order they should be at the end however as we can see it's in middle can someone help me this. I need to sort this data in ascending order.

Help would be much appreciated.

Thanks !

[Smalfly · Accepted solution]

Hi @Tara_01 

This is probably due to the data type of the data in 'column A'.

Can you try to convert your text to a number format?

This can be done through transform data (then the format will be changed in the entire report) of with a value function (just for this visual).