topic DataviewMappings Table with two measures in Developer https://community.fabric.microsoft.com/t5/Developer/DataviewMappings-Table-with-two-measures/m-p/1551809#M26776 <P>Dear PBI custom viz developer community,</P><P>&nbsp;</P><P>I have a set of data in the from of</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD><STRONG>X Values</STRONG></TD><TD><STRONG>Y1 Values</STRONG></TD><TD><STRONG>Y2 Values</STRONG></TD><TD><STRONG>Overwritten</STRONG></TD></TR><TR><TD>1</TD><TD>50</TD><TD>50</TD><TD>1</TD></TR><TR><TD>2</TD><TD>45</TD><TD>42</TD><TD>0</TD></TR><TR><TD>2</TD><TD>47</TD><TD>42</TD><TD>0</TD></TR><TR><TD>3</TD><TD>33</TD><TD>34</TD><TD>1</TD></TR><TR><TD>3</TD><TD>31</TD><TD>34</TD><TD>0</TD></TR><TR><TD>3</TD><TD>30</TD><TD>34</TD><TD>0</TD></TR><TR><TD>4</TD><TD>21</TD><TD>26</TD><TD>0</TD></TR><TR><TD>4</TD><TD>10</TD><TD>26</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need to create a datamapping to be able to visualise the data</P><P>X values are my categorical data,</P><P>Y1 values should not be summarised and I am using them to display as a scatterplot,</P><P>Y2 values are my summarised data as averages of Y2 at each X1 which I am displaying as a line</P><P>Overwritten will be used as my legend, (if the value is 1 show as different colour)&nbsp;</P><P>&nbsp;</P><P>I would need your help to understand what would be the best dataviewmapping for developing a custom visuals given the above data</P><P>&nbsp;</P><P>Appreciate your help&nbsp;</P><P><LI-MESSAGE title="D3.JS CustomVisual - Are interactions possible?" uid="381841" url="https://community.powerbi.com/t5/Developer/D3-JS-CustomVisual-Are-interactions-possible/m-p/381841#U381841" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"></LI-MESSAGE>&nbsp;</P><P><LI-MESSAGE title="DataViewMappings with both table and categorical." uid="511744" url="https://community.powerbi.com/t5/Developer/DataViewMappings-with-both-table-and-categorical/m-p/511744#U511744" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"></LI-MESSAGE>&nbsp;</P> Tue, 15 Dec 2020 16:28:19 GMT Anonymous 2020-12-15T16:28:19Z DataviewMappings Table with two measures https://community.fabric.microsoft.com/t5/Developer/DataviewMappings-Table-with-two-measures/m-p/1551809#M26776 <P>Dear PBI custom viz developer community,</P><P>&nbsp;</P><P>I have a set of data in the from of</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD><STRONG>X Values</STRONG></TD><TD><STRONG>Y1 Values</STRONG></TD><TD><STRONG>Y2 Values</STRONG></TD><TD><STRONG>Overwritten</STRONG></TD></TR><TR><TD>1</TD><TD>50</TD><TD>50</TD><TD>1</TD></TR><TR><TD>2</TD><TD>45</TD><TD>42</TD><TD>0</TD></TR><TR><TD>2</TD><TD>47</TD><TD>42</TD><TD>0</TD></TR><TR><TD>3</TD><TD>33</TD><TD>34</TD><TD>1</TD></TR><TR><TD>3</TD><TD>31</TD><TD>34</TD><TD>0</TD></TR><TR><TD>3</TD><TD>30</TD><TD>34</TD><TD>0</TD></TR><TR><TD>4</TD><TD>21</TD><TD>26</TD><TD>0</TD></TR><TR><TD>4</TD><TD>10</TD><TD>26</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need to create a datamapping to be able to visualise the data</P><P>X values are my categorical data,</P><P>Y1 values should not be summarised and I am using them to display as a scatterplot,</P><P>Y2 values are my summarised data as averages of Y2 at each X1 which I am displaying as a line</P><P>Overwritten will be used as my legend, (if the value is 1 show as different colour)&nbsp;</P><P>&nbsp;</P><P>I would need your help to understand what would be the best dataviewmapping for developing a custom visuals given the above data</P><P>&nbsp;</P><P>Appreciate your help&nbsp;</P><P><LI-MESSAGE title="D3.JS CustomVisual - Are interactions possible?" uid="381841" url="https://community.powerbi.com/t5/Developer/D3-JS-CustomVisual-Are-interactions-possible/m-p/381841#U381841" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"></LI-MESSAGE>&nbsp;</P><P><LI-MESSAGE title="DataViewMappings with both table and categorical." uid="511744" url="https://community.powerbi.com/t5/Developer/DataViewMappings-with-both-table-and-categorical/m-p/511744#U511744" discussion_style_icon_css="lia-mention-container-editor-message lia-img-icon-forum-thread lia-fa-icon lia-fa-forum lia-fa-thread lia-fa"></LI-MESSAGE>&nbsp;</P> Tue, 15 Dec 2020 16:28:19 GMT https://community.fabric.microsoft.com/t5/Developer/DataviewMappings-Table-with-two-measures/m-p/1551809#M26776 Anonymous 2020-12-15T16:28:19Z