How to sort dimension on basis of its numeric values ?

[satyaban]

Dear All,

I have a field called app version with values like

Appversion list = 1.2.3, 2.4.5, 5.4.5, 4.5.6    so on ....  like this But when bar graph is plotted it should show as 

5.45 , 4.5.6 , 2.4.5 , 1.2.3 so on ....... based on magnitude of dimension values   instead of ascending/descending sorting of measure values .

Kindly help how to write expression for sorting same dimension values based on magnitude values .

Note: I have applied sort numerically for dimension values  in sorting section but it is not working .

[satyaban]

Yes After dragging APP_VERSION dimension field to first position over measure it is sorting but not for all values 

ex: it sort like  7.6 , 8.5, 9.1 , 7.6.1, 8.5.2 , 9.1.0 but it should be 7.6 ,7.6.1 ,8.5 , 8.5.2 ,9.1 , 9.1.0 like this

issue seems to be for decimal points values .

[asinha1991]

can you remove custom condition and sort alphabetically?

[satyaban]

Sorry Still It is not working 
Please check attached image

[StarinieriG · Accepted solution]

Maybe this could work

Left(PurgeChar(num,'.') & Repeat(0,Max(total Len(Purgechar(num,'.')))), Max(total Len(Purgechar(num,'.'))))

[asinha1991 · Accepted solution]

sorry for throwing random things 😄 try this if it doesn't work I will load data and see

Num#(Purgechar(APP_VERSION, '.'))/pow(10,len(Purgechar(APP_VERSION, '.'))) 

[satyaban]

Finally It worked .

Thanks a lot @asinha1991   @StarinieriG  for your quick response.

I will mark your solutions as accepted. Closing this issue 😄