Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
To make it simple, i have three variables X, Y, Z
I have set up a scatter plot which represent X on axe X, Y on axe Y and Z as a dotes (as Legend). Z are dates. As you can see, each dates has a different color. I would like to know if i can easely set something like : most recent 10 dotes in Bleu, all the other one in Red. Or even better most recent 10 dotes in Brigh Red, between 10 an 50 : lighter red, 50 to 100, lighter lighter red 100 to 200 in black, in order to visualise how my data has evolved with the time passing.
Thanks in advance for your help
Cheers
Pierre
Solved! Go to Solution.
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
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
Your solution is properly perfect
Many thanks
Pierre