Forum Discussion

mafioso's avatar
mafioso
Icon for Helper II rankHelper II
8 years ago

Sorting numbers doesn't work properly in Power BI

Hi I want to sort some numbers ASC oder DESC. As you see in the screenshot, that doesn't work properly because Power BI thinks that the dot is a thousand separator and not a decimal one. So how can I solve this issue? In my Excel file, which I load into Power BI, I've tried to change it to both a comma and a dot but nothing seems to work. 

Any help would be appreciated!

Need Help

2 Replies

  • Interkoubess's avatar
    Interkoubess
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hi mafioso,

     

    You can load your data in Power Query then change the dot to comma and select Decimal type for example then sort it.

     

    Let us know if it does not work, so give us raw data easy to copy and paste ( not an image).

     

    Thx.

     

    Ninter

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    mafioso,

    Do you use the latest version of Power BI Desktop and do you change the data type of the column to Decimal number in Query Editor of Power BI Desktop?


    Regards,
    Lydia