Scatter plot different color shade

Hi pitucc,

You can create a rank calculated column based on Z, then create another column similar the formula.

color = IF(Table[Rank]<=10,"Red",IF(Table7[Rank]<=50,"lighter red",IF(Table[Rank]<=100,"lighter lighter red","black")))

Then add the Z field as Detail level, the color as Lengend, then adjust the Lengend color using the hammer button.

I try to reproduce using my sample table, please review.

1. Create calculated column using the formulas.

Rank = RANKX(Table7,Table7[Z],,DESC,Dense)
color = IF(Table7[Rank]<=2,"Red",IF(Table7[Rank]<=5,"Green","yellow"))

You will get the results as follows.



2. Create a scatter chart. Click the hammer buttom, and select the expected color.



You will get expected result as follows, please note the X,Y,Z,color fields.



Best Regards,
Angelia