Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to fix ordering by column as number?

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?

 

 

 

 

Need Help

2 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    hi Anonymous 

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

     

    Regular,

    Lin

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      hi v-lili6-msft 

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

      Could you show   detailed screenshot, please?