Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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
adityavighne
Continued Contributor
Continued Contributor

@Anonymous 

 

check below pic for color coding scatter plot.

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

 

color.PNG

Anonymous
Not applicable

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?

Unable this for plot

color2.PNG

Anonymous
Not applicable

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

 

@Anonymous 

 

Move Group A/B up/above customer number

Anonymous
Not applicable

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

Check what you have taken on the x-axis.

 

or give more details 

Anonymous
Not applicable

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.