Change sort order on Y axis in Scatter chart

[MouserMike]

I've created a simple scatter chart to compare Rank with Prioritization Score.  Rank is manually determined by our users, where Prioritization score is calculated based on some other field settings.  Rank is set as 1, 2, 3,... with 1 being the highest; Prioritization Score is from 1 to 100 with 100 being the highest (the opposite sorting of Rank).

When I set Rank as the Y Axis, it automatically sorts with the highest values at the top, but I want the lowest values at the top, since the lowest value represents the highest rank. Is this possible?  When I click the ellipse in the upper right of the visual, there is no Sort option.

Also, every item in the list has a Prioritization Score value since it's calculated, but not every item has a Rank; those without a Rank are omitted from the visual.  Is it possible to have them appear in the visual with an assumed Rank value?

[v-yuta-msft]

@MouserMike ,

Based on the description, the rank column is in value field. right? You can click ellipse on the top-right of the the scatter chart, select "Sort bu sum of rank", then click "Sort ascending" like below:

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MouserMike]

There is no "Sort" option when clicking the ellipse in the top right corner of the scatter chart.

[KayceVC]

Is your scatter chart using Direct Query? I have one that uses this data method and it also does not have the Sort option on the visual.

What you might be able to do get around the chart naturally sorting smallest to largest was to create a calculated column that takes your Rank, multiply it by 100 then divided it by the original Rank. This would turn 1 to 100, 2 to 50, etc then use that as your Y axis and show your actual Rank in the tooltip.  

[MouserMike · Accepted solution]

I tried that and it worked (actual calculation would be 1/[Rank]*100), but I think that would be too confusing for the users reviewing the report, since the numbers shown on the chart axis aren't the Rank values they assigned to each item. 

I'll stick with the basic Rank value on the chart and just make sure they know which quadrant to look in.