DataviewMappings Table with two measures

Dear PBI custom viz developer community,

I have a set of data in the from of

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

Forum Discussion