How to fix ordering by column as number?

[volodymyrz]

Hi everyone,

Could you  suggest how to  fix ordering  by column as number, please?  

I'm using live connection to SSAS. There is  "Price" column  as double datatype in dimension. When I try to order by this column in table the result is different what I expect. Looks like this column was ordered as string datatype

Bellow the properties of this column in SSAS.  Coud you point what's wrong with properties?

[v-lili6-msft]

hi @volodymyrz 

The data type is "Regular", try to change it as "Double".

Regular,

Lin

[volodymyrz]

hi @v-lili6-msft 

Thank you for answer, but I don't see option what you suggest

Could you show   detailed screenshot, please?