Colour scatter chart data by year rather than day

[Anonymous]

Hi everyone,

Pretty new to Power BI and trying to figure things out. I have made the below scatter chart which plots the data I want correctly. The data is coloured by the day it was collected and I have a slicer to select the well I want. Is there a way to maintain the individual data points but colour them based on year rather than the day? I've tried playing around with grouping or binning them but this seems to muck up the plot.

Any help would be appreciated.

Cheers

Alan

[OwenAuger · Accepted solution]

Hi Alan,

Yes you should be able to do this as follows:

1. Put the Date field into Details, so that both Well & Date are in Details.
2. Click the double-headed arrow in the visual header to drill-down so that you have one point per Well/Date combination (may not be needed?) 
3. Put the Year field into Legend. This will colour the points by Year.

Hopefully that works. Please post back if needed.

Regards,

Owen

[Anonymous]

Thanks Owen!

That works great. I just had to remove well from Details.

Cheers

Alan