Scatter chart change color

[enavesca]

I have created a scatter chart where I plot the result from the calculation 'Score/size_number.' The markers are colorized by 'Initiative name' (projects). However, I need to colorize them by 'coordination level.' As a consequence, when someone selects  'coordination level' from the slice, the initiatives will be shown in accordance with each team under the 'coordination level.'

For example: when someone selects DIO (coordination level), the chart will show the initiatives in four different colors (DIO -DAS, DIO -DIO, DIO -SF, DIO - STRAT).

I appreciate any help 

Thanks!

[v-zhouwen-msft · Accepted solution]

Hi @enavesca ,

Regarding your question, you can modify this in the visualization settings of the scatterplot.

The Table data is shown below:

Please follow these steps:

Setting items in the same category to the same color.

Final output:

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-zhouwen-msft · Accepted solution]

Hi @enavesca ,

Regarding your question, you can modify this in the visualization settings of the scatterplot.

The Table data is shown below:

Please follow these steps:

Setting items in the same category to the same color.

Final output:

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[enavesca · Accepted solution]

Amazing!

Thank you very much 🙌

I have just one concern. There are more than 100 projects, I wonder if there is a way to do it with less effort.