Forum Discussion
Sort a columns by the rows
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
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.
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
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
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.
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
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.