Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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
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.
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
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
Thanks for sharing correct solution.
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.
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.
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |