Re-ordering the x-axis values

[AVZ]

In the first Chart im trying to order it by ascending, starting with 0-1 ending with >5.

For the second chart I want to order days starting with monday ending with friday.

Any help would be greatly appreciated!

[dhaval0011]

This bug still persists.

Ideally, it should function at least in simplest form, i.e. how data is provided it should plot it on chart.

In my table, WK 1 is first and WK 8 is last. In one line chart, it takes correct order from WK 1 to WK 8. But in another one, it starts with WK 7 and jumbles futher.

[v-jiascu-msft]

Hi @AVZ,

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

Best Regards!
Dale

[Anonymous · Accepted solution]

Hi @AVZ,

This subject is explained in the Power BI documentation.

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-change-how-a-chart-is-sorted/

Hope you find your answer here 🙂

Regards,

L.Meijdam

[Anonymous]

Thanks for sharing correct solution.

[Anonymous]

Hi @Anonymous @AVZ 

What if I don't want to use a numeric value or a text field for the sort order?  I have a requirement to sort by a process step, e.g. cut, paint, quality control, ship.  I will have a certain number of works orders in each step.  I want to show that on a bar chart.  The chart will immediately draw attention to any step where works orders are backlogged. 

Neither the number of orders in a step nor the alphabetic sort or of the step name is suitable for sorting the bar chart in the chronological sequence of process steps.

[tushartechlab]

Hey @Anonymous 

In this case what you can do is, put the set of process in a table and order them by a key. Then in Power BI take this key as well as a field. Click on the column that you want ordered in graph -> go to modelling tab -> go to sort by column -> select the key column that you used in database for ordering. 

And you are done.

Let me know if the doubt exists.