Forum Discussion

Jay2077's avatar
Jay2077
Helper III
9 years ago
Solved

Data Colors in Scatter Chart

Hi all, I was wondering what the minimum, Center and Maximim refer to in the color saturation options on the scatter chart.  Basically I want any values below 40 to be red between 40 - 69 to be amb...
  • v-yulgu-msft's avatar
    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

  • v-yulgu-msft's avatar
    v-yulgu-msft
    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