Forum Discussion
Colour scatter chart data by year rather than day
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
Hi Alan,
Yes you should be able to do this as follows:
- Put the Date field into Details, so that both Well & Date are in Details.
- 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?)
- Put the Year field into Legend. This will colour the points by Year.
Hopefully that works. Please post back if needed.
Regards,
Owen
2 Replies
- OwenAuger
Super User
Hi Alan,
Yes you should be able to do this as follows:
- Put the Date field into Details, so that both Well & Date are in Details.
- 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?)
- Put the Year field into Legend. This will colour the points by Year.
Hopefully that works. Please post back if needed.
Regards,
Owen