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