Descending Sort in Graph without changing data type to Number

[Keith011]

Hi There,

This is my chart sorted DESCENDING order

This is my chart sorted ASCENDING order

Somehow Power BI doesn't read "10" as a "10", it reads as a "1-0" ? How do I make it sorted by Descending order 10,9,8,7,6,5,4,3,2,1?

I know changing the Type to Number and sort will definitely work. But I cant do that, Because My dataset is unpivoted, so the column itself contains text and values, i can't change type to Number , my other charts will hit an error

Is there a workaround for this?

[Nishudhan]

Could you please provide some more input to better understand the scenario..provide the dataset image.

[Idrissshatila]

Hello,

sure, check this microsoft article that would walk you through the steps.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto...

If I answered your question, please mark my post as solution so it would appear to others, Appreciate your Kudos👍

Follow me on Linkedin

[Idrissshatila]

Hello,

You could add a column for your sorting and sort the used  column in the graph by this new sort column.

like this one

If I answered your question, please mark my post as solution so it would appear to others, Appreciate your Kudos👍

Follow me on Linkedin