Forum Discussion
Individual Scatter Plot Legend / Class
Hi experts!
I have a scater plot that shows me the sales per week.
Time dimensions (Year, Month, Week) are on the X Axes.
The Sales amout is on the Y Axes.
Now I would like to get 4 colours for the Dot / Icon based on the Sales Amount:
- Green: Sales > 500
- Yellow: Sales > 400 & < 500
- Red: Sales > 200 & < 400
- Purple: Sales = 0
I would like to display this "Level" in the legend with the associated colour for the icons.
But how?
If course I can add this rules into customized series for each icon based on the Sales measure.
But then I'm still lacking the legend.
joshua1990 , if you use legend then I doubt you can use conditional formatting. Otherwise you can create a color measure and use that in conditional formatting using the field value option
Color = Switch(True() ,
[Sales] > 500 , "Green",
[Sales] > 400 , "Yellow",
[Sales] > 200 , "Red",
"Purple"
)
How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4
1 Reply
joshua1990 , if you use legend then I doubt you can use conditional formatting. Otherwise you can create a color measure and use that in conditional formatting using the field value option
Color = Switch(True() ,
[Sales] > 500 , "Green",
[Sales] > 400 , "Yellow",
[Sales] > 200 , "Red",
"Purple"
)
How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4