Dear PBI custom viz developer community,
I have a set of data in the from of
| X Values | Y1 Values | Y2 Values | Overwritten |
| 1 | 50 | 50 | 1 |
| 2 | 45 | 42 | 0 |
| 2 | 47 | 42 | 0 |
| 3 | 33 | 34 | 1 |
| 3 | 31 | 34 | 0 |
| 3 | 30 | 34 | 0 |
| 4 | 21 | 26 | 0 |
| 4 | 10 | 26 | 1 |
I need to create a datamapping to be able to visualise the data
X values are my categorical data,
Y1 values should not be summarised and I am using them to display as a scatterplot,
Y2 values are my summarised data as averages of Y2 at each X1 which I am displaying as a line
Overwritten will be used as my legend, (if the value is 1 show as different colour)
I would need your help to understand what would be the best dataviewmapping for developing a custom visuals given the above data
Appreciate your help
D3.JS CustomVisual - Are interactions possible?
DataViewMappings with both table and categorical.
