Forum Discussion
Data Colors in Scatter Chart
- 9 years ago
Hi Jay2077,
The bubble will be filled with gradual color based on the field added to color saturation option. Take below sample data as an example. We can see that the max value of field [Color] is 0.8, so, it corresponding category "Janet" is shown with highest saturation. Please note as the field added to color saturation section, it will be sum up automatically, in order to keep its original value, here, we select "Average".
To workaround your requirement that set bubble color based on its value, we could create a new category group. As you can see, in my test, the sales value was sum up based on category.
So, I added a calculated column as below: (please modify the CALCULATION section according to your scenario)
Color group = IF ( CALCULATE ( SUM ( 'Sales of team'[Sales] ), ALLEXCEPT ( 'Sales of team', 'Sales of team'[Name] ) ) <= 20, "Color1", IF ( CALCULATE ( SUM ( 'Sales of team'[Sales] ), ALLEXCEPT ( 'Sales of team', 'Sales of team'[Name] ) ) > 40, "Color2", "Color3" ) )
In Scatter Chart, add this new group [Color group] to legend. Under "Format" pane, you can customize the data color based on new category.
Best regards,
Yuliana Gu - 9 years ago
Hi Jay2077,
In my test, the data poins show the same color in service as that in desktop. In your scenario, please log in service using a different browser to see whether is works. Besides, please test whether issue persists if setting data points to different colors.
Regards,
Yuliana Gu
Many thanks for your help however, there is no legend option in my format pane.
Ignore my last comment I found the legend option, however now when I publish my report I cannot see the colours in the scatter (red, amber green) as I specified, instead the data points show all multi coloured.
Do you know why this is ?