Tornado chart - keep one side static after sorting, then sort other side

[Dawn_Juarez]

Newer to PowerBI - I'm trying to figure out how to sort a tornado chart by the left side (as shown), but then leaving that static and sorting the right-side descending as that would be a tiebreaker. In the example you can see 4 bars are tied at 100, I need to keep in descending order of 181 down to 61 (on the left) but then need any ties sorted descending as well. I labelled the 4 bars of 100 to show what order they should be in. I've included the order everything should show in, however that was manually done, not feasible to do this moving forward so looking for a solution.

Alternatively, another visual that could do this same thing, so far I've not found one that does this.

[sevenhills · Accepted solution]

Try this as last option:

Add a column and hide it from users, say sortcol

SortCol = VALUE('Table'[Total Sales] & "." & 'Table'[Sales in U. S.])

In the table view, select the column "Item" and go to column tools, sort by "SortCol"

Go to visual, select the sort as item and as descending, it should work. 

Check the output, it should be showing the way you want 🙂 

[sevenhills · Accepted solution]

Try this as last option:

Add a column and hide it from users, say sortcol

SortCol = VALUE('Table'[Total Sales] & "." & 'Table'[Sales in U. S.])

In the table view, select the column "Item" and go to column tools, sort by "SortCol"

Go to visual, select the sort as item and as descending, it should work. 

Check the output, it should be showing the way you want 🙂 

[Dawn_Juarez]

When I do the SortCol I get this error Cannot convert value '.' of type Text to type Number.

[sevenhills · Accepted solution]

what is the formula you used? what are the columns data type used in the formula? 

The trick and my idea was to concatenate the two numbers.

one before the decimal and use other after the decimals.
and convert the concatenated back to decimal number. make the column hidden.
Use this calculated decimal column for item column sorting, which solves your need!

hope this clarifies why I am using!

[Dawn_Juarez]

Thank you, yes I understand the premise of what you were doing. Appreciate your reply.