Moving a data point in Chart

[vishwanathans]

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

[amitchandak]

@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

[vishwanathans]

@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-jingzhang]

Hi @vishwanathans 

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.

[vishwanathans]

Oh i am sorry. I could have been clear.

Ranking was not in the dataset it was added through dax function. Possible to fix this?

[v-jingzhang]

@vishwanathans 

Sorry that I couldn't come up with a perfect solution to this.

A small trick is to add a space before "All Other" like " All Other", then sort the visual by Client Ranking descendingly and it will display like below. But if it is not possible to change the "All Other" value, this trick will not work.

Another trick is to add a new column Ranking with the following DAX code and use it in the visual as Axis. In this way, the visual looks not beautiful enough.

---

---

Sort Order = IF('Tbl'[Client Ranking]="All Other",COUNTROWS('Tbl'),RANKX(FILTER('Tbl','Tbl'[Client Ranking]<>"All Other"),'Tbl'[Client Ranking],,ASC))

Ranking = [Sort Order] & " " & [Client Ranking]

 

Looking forward to more solutions!

Best Regards,
Community Support Team _ Jing Zhang

[Syndicate_Admin]

Oh yeah it messes up the entire visual.

Ok bit out of topic. Please help me if you could.

Here is my visual below. I wanted the month on the column to be sorted in decending order (October to show first). Can you please be able to help me on this.

[v-jingzhang]

@vishwanathans Not sure what's your table like, please take the following method for reference.

Add a column with DAX Month Sort = 13 - MONTH(Test[Date]), then sort Month column by Month Sort column.