Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |