Forum Discussion
Moving a data point in Chart
Hi All,
This is my example data.
This is my result when i apply a visualization to the data.
Is there a way can we take the "All Other" data point to far right?
Thanks in advance.
Srini
7 Replies
- amitchandakSuper User
vishwanathans , You have to create a sort column for client_ranking based on the order you want and mark that as the sort column
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
- vishwanathansHelper II
amitchandak I tried to sort the data. But in all the way "All Other" data point is in the second position. Due to its value being the 2nd highest. Any fix for this?
- v-jingzhangCommunity Support
You could first add an index column in Query Editor -> Add Columns -> Index Column and make sure that "All other" row has the largest index number. Then in Desktop's Data view, select Client Ranking column and select Column tools -> Sort by column -> Index. Finally click ... on the visual to make it sort by Client Ranking ascendingly and you will get what you need.
Best Regards,
Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.