Sort from a column in a table in the DASHBOARD NOT IN POWER QUERY

[Syndicate_Admin]

Hello, how are you doing!

I hope someone can help me with this doubt I have.

I have a table that with the help of a TOP N filter throws me the 10 best technologies that have the highest investment.

I would like to know if you can sort the column called INVERSION in order from highest to lowest so that the rows appear according to the largest amount and so on.

I already clicked on the three points and gave it order by investment and in a descending way but apparently it does not order it for the entire amount but it orders it by the first digit it has.

Does anyone know how to soulucionarlo?

[vicky_ · Accepted solution]

Make sure the type of the inversion column is a number. Right now, PowerBI thinks it's a word / string so that column is being sorted alphabetically.