cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DatAfke Regular Visitor
Regular Visitor

How to colour data points of visual based on a categorisation?

Hi All. I have the following plot:

Knipsel.PNG

 

How can I change the colour of the datapoints by a data categorisation:

datapoint 1 = group A

datapoint 2 = group A

datapoint 3 = group B

datapoint 4 = group A

 

?

 

A lot of datapoints, so I donnot want to do this by hand. Also doing this manual, does not allow me to add a legend with the groups.

thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
DatAfke Regular Visitor
Regular Visitor

Re: How to colour data points of visual based on a categorisation?

I finally figured it out, it was very simple. You just put the variable  you would like to colour the datapoints on in the Legend section instead of in Details section.

View solution in original post

8 REPLIES 8

Re: How to colour data points of visual based on a categorisation?

@DatAfke 

 

check below pic for color coding scatter plot.

Select plot -> Go to -> Format -> Data color -> unable show all

 

color.PNG

DatAfke Regular Visitor
Regular Visitor

Re: How to colour data points of visual based on a categorisation?

Thank you for your reply. However now I need to change the colour of each datapoint manually, which also does not allow me to add a legend.

 

Is there an option to do this automatically?

Re: How to colour data points of visual based on a categorisation?

Unable this for plot

color2.PNG

DatAfke Regular Visitor
Regular Visitor

Re: How to colour data points of visual based on a categorisation?

Thanks! Now it looks like this:

Knipsel.PNG

However, it colours by customer number (see below), but I would like to colour it by Group A/B variable. How to achieve this?

Knipsel1.PNG

 

Re: How to colour data points of visual based on a categorisation?

@DatAfke 

 

Move Group A/B up/above customer number

DatAfke Regular Visitor
Regular Visitor

Re: How to colour data points of visual based on a categorisation?

Knipsel.PNGThen my entire plot changes (like this 😞 )

Re: How to colour data points of visual based on a categorisation?

Check what you have taken on the x-axis.

 

or give more details 

DatAfke Regular Visitor
Regular Visitor

Re: How to colour data points of visual based on a categorisation?

I finally figured it out, it was very simple. You just put the variable  you would like to colour the datapoints on in the Legend section instead of in Details section.

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)