Sort a columns by the rows

[Nazar]

How to sort columns in column chart the same way like rows in table are situated http://take.ms/pWh6T
In order to be in such way http://take.ms/i9huS

b/c now it sorts columns by Alphabetic order http://take.ms/fCQyU

[Sean · Accepted solution]

Create a Method Order Column - giving each Method its custom order number (you may have to use 01, 02... for first 9)

then concatenate the 2

Method Sort = [Method Order]&". "&[Method]

And use that column in the Chart

[Sean]

@Nazar

In the top right corner of your chart - click the 3 dots - select Sort By - pick your choice - then you can sort either AZ or ZA

[Nazar]

I want to maintain such order http://take.ms/zTGQd , not alphabetic 
in order that columns http://take.ms/gctQ4 meet position of row in the table http://take.ms/9n0bx

[Sean · Accepted solution]

Create a Method Order Column - giving each Method its custom order number (you may have to use 01, 02... for first 9)

then concatenate the 2

Method Sort = [Method Order]&". "&[Method]

And use that column in the Chart

[Nazar]

it still something wrong http://take.ms/MluGe
even after I click Sort By Method sort http://take.ms/3ac7c it still nothing
this is table http://take.ms/BqIQs

[Sean]

@Nazar

Convert the numbers to TEXT (in the column before you concatenate) and add 0 to the first 9 numbers

so they are 01, 02, 03, ..., 09, 10, 11 etc...

That should do it.

[Nazar]

I do that http://take.ms/C6iGv but when I copy it to Power BI transforms it to such view http://take.ms/A8a8S

In Edit Queries when I click Source It shows 01, 02, 03 http://take.ms/sFkOa

[Sean · Accepted solution]

Don't Load the Data - click Edit


Then in the Query Editor - BEFORE you load - change the Data Type - the zeros should show up

Hopefully this takes care of it.

[Nazar]

thanks:)