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...
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    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

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

Jay2077's avatar
Jay2077
Helper III
9 years ago

Hi v-yulgu-msft

 

I followed your instructions and they work great on my desktop version, however when I publish my report/dashboard the data points are various colours and not the red, orange and green that I specified with the categories (through the if statements) and as they appear on the desktop.

 

Why is this ?  How do I resolve this please?

 

Any help greatly appreciated.

 

Thanks

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