sort a scatterplot by legend

[Anonymous]

Hello! I am trying to make my scatterplot be displayed in alphebetical roder by provider_name. I added the name dimension to the legend, but it seems to be sorting the x-axis by provider name, and then also by the name (of the practice).

How can I just make it alphabetical by provider_name? That way all of the name(practice) colors are all scattered.

I've tried clicking on the three dots to sort, but these are the options it gives me. WHen I click on revenue it does the same thing (sorting by revenue AND by practice name)

Thanks in advance!

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

Where does your problem exist? I’ve also created some data and make some tests, then I found that it’s sorted alphabetically by [provider_name] if I selected the “Sort by [provider_name]” and didn’t place any field in the “Name” of the chart. When I placed the field in the “Legend”, the “Sort by” doesn’t work, it’s now sorted by the value in the “Legend” field.

As a result, I suggest you to remove the field in the “Legend” field of this chart if it’s possible. Or you can place a rank column to rank the [provider_name] alphabetically and place it into the “Legend” field of this chart.

Rank = RANKX('Table',[Provider name],,ASC,Dense)

And you can get what you want.

You can download my test pbix file here

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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

[Anonymous]

@v-robertq-msft - when I did this, this is the error message that I got.... what should I do now?

[Anonymous]

Nevermind!  I realized you have to add this as a new column to your table - not make a new measure!  Thanks so much!