topic Re: line chart with data pairing in Developer https://community.fabric.microsoft.com/t5/Developer/line-chart-with-data-pairing/m-p/3173343#M42079 <P>Hi&nbsp;@Anonymous</a>&nbsp;,</P><P>&nbsp;</P><P>Great to know it helped! If it solved your problem, please mark it as solution <span class="lia-unicode-emoji" title=":heavy_check_mark:">✔️</span></P><P>&nbsp;</P><P>Regarding your question, please use the field in the following way:</P><UL><LI><STRONG>Category:</STRONG> Date</LI><LI><STRONG>Value 1:</STRONG> Accepted</LI><LI><STRONG>Value 2:</STRONG> Defective</LI><LI><STRONG>Legend:</STRONG> ProductID</LI></UL><P>&nbsp;</P><P>Hope this answer solves your problem!<BR />If you need any additional help please <SPAN>@</SPAN> me in your reply.<BR />If my reply provided you with a solution, please consider marking it as a solution <span class="lia-unicode-emoji" title=":heavy_check_mark:">✔️</span> or giving it a kudoe <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span><BR /><BR />Thanks!<BR />Best regards,<BR />Joao Ribeiro</P> Wed, 05 Apr 2023 08:48:43 GMT joaoribeiro 2023-04-05T08:48:43Z line chart with data pairing https://community.fabric.microsoft.com/t5/Developer/line-chart-with-data-pairing/m-p/3169090#M42051 <P>Hi</P><P>&nbsp;</P><P>Does anyone knows if it is possible to have data pairing on a line chart?</P><P>For example, with the data set as follows:</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Date</TD><TD>ProductID</TD><TD>Defective</TD><TD>Accepted</TD></TR><TR><TD>1/3/2023</TD><TD>1</TD><TD>90</TD><TD>1000</TD></TR><TR><TD>1/3/2023</TD><TD>2</TD><TD>200</TD><TD>1200</TD></TR><TR><TD>1/3/2023</TD><TD>3</TD><TD>100</TD><TD>1500</TD></TR><TR><TD>1/3/2023</TD><TD>4</TD><TD>30</TD><TD>1500</TD></TR><TR><TD>2/3/20203</TD><TD>1</TD><TD>50</TD><TD>1300</TD></TR><TR><TD>2/3/20203</TD><TD>2</TD><TD>150</TD><TD>2300</TD></TR><TR><TD>2/3/20203</TD><TD>3</TD><TD>80</TD><TD>1600</TD></TR><TR><TD>2/3/20203</TD><TD>4</TD><TD>350</TD><TD>1800</TD></TR><TR><TD>3/3/2023</TD><TD>1</TD><TD>230</TD><TD>1900</TD></TR><TR><TD>3/3/2023</TD><TD>2</TD><TD>140</TD><TD>1400</TD></TR><TR><TD>3/3/2023</TD><TD>3</TD><TD>320</TD><TD>1500</TD></TR><TR><TD>3/3/2023</TD><TD>4</TD><TD>40</TD><TD>1200</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I was trying to create a line chart with 4 sets of lines (one solid, one dotted) to represent each productid, with 2 lines each; one for defective and one for accepted.</P><P>With the date in the x-axis field, and productid in the Legend field, I am unable to add more than 1 column in the y-axis field; hence am unable to create the 8 lines I was hoping to.</P><P>Was hoping to get some help here in this channel.</P><P>Any guidence is greatly appreciated!</P><P>Thank you!</P><P>&nbsp;</P> Mon, 03 Apr 2023 10:51:41 GMT https://community.fabric.microsoft.com/t5/Developer/line-chart-with-data-pairing/m-p/3169090#M42051 Anonymous 2023-04-03T10:51:41Z Re: line chart with data pairing https://community.fabric.microsoft.com/t5/Developer/line-chart-with-data-pairing/m-p/3171628#M42070 <P>Hi&nbsp;@Anonymous</a>&nbsp;,</P><P>&nbsp;</P><P>With the native line chart you can use the small multiples to open the chart per ProductID, as shown below:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="joaoribeiro_0-1680608966184.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/897250i5890B6E8ED15A215/image-size/medium?v=v2&amp;px=400" role="button" title="joaoribeiro_0-1680608966184.png" alt="joaoribeiro_0-1680608966184.png" /></span></P><P>&nbsp;</P><P>Besides that, you have the "Advanced Line Chart" in the AppSource. Please find below how the free version looks like:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="joaoribeiro_1-1680609237919.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/897252iA9B241EF75E46F31/image-size/medium?v=v2&amp;px=400" role="button" title="joaoribeiro_1-1680609237919.png" alt="joaoribeiro_1-1680609237919.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="joaoribeiro_2-1680609280860.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/897253iDBFAB53C8281FE0B/image-size/medium?v=v2&amp;px=400" role="button" title="joaoribeiro_2-1680609280860.png" alt="joaoribeiro_2-1680609280860.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P><P>Hope this answer solves your problem!<BR />If you need any additional help please <SPAN>@</SPAN> me in your reply.<BR />If my reply provided you with a solution, please consider marking it as a solution <span class="lia-unicode-emoji" title=":heavy_check_mark:">✔️</span> or giving it a kudoe <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span><BR /><BR />Thanks!<BR /><BR />Best regards,<BR />Joao Ribeiro</P><P>&nbsp;</P> Tue, 04 Apr 2023 11:55:32 GMT https://community.fabric.microsoft.com/t5/Developer/line-chart-with-data-pairing/m-p/3171628#M42070 joaoribeiro 2023-04-04T11:55:32Z Re: line chart with data pairing https://community.fabric.microsoft.com/t5/Developer/line-chart-with-data-pairing/m-p/3172697#M42078 <P>Thanks&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/539647">@joaoribeiro</a>&nbsp;This is really helpful. May I know what are the fields that should be input to achieve the lines you have on the advanced line chart? Thanks again!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="curiouscat_0-1680652303157.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/897509iAD73BEA72B154966/image-size/medium?v=v2&amp;px=400" role="button" title="curiouscat_0-1680652303157.png" alt="curiouscat_0-1680652303157.png" /></span></P><P>&nbsp;</P> Tue, 04 Apr 2023 23:51:54 GMT https://community.fabric.microsoft.com/t5/Developer/line-chart-with-data-pairing/m-p/3172697#M42078 Anonymous 2023-04-04T23:51:54Z Re: line chart with data pairing https://community.fabric.microsoft.com/t5/Developer/line-chart-with-data-pairing/m-p/3173343#M42079 <P>Hi&nbsp;@Anonymous</a>&nbsp;,</P><P>&nbsp;</P><P>Great to know it helped! If it solved your problem, please mark it as solution <span class="lia-unicode-emoji" title=":heavy_check_mark:">✔️</span></P><P>&nbsp;</P><P>Regarding your question, please use the field in the following way:</P><UL><LI><STRONG>Category:</STRONG> Date</LI><LI><STRONG>Value 1:</STRONG> Accepted</LI><LI><STRONG>Value 2:</STRONG> Defective</LI><LI><STRONG>Legend:</STRONG> ProductID</LI></UL><P>&nbsp;</P><P>Hope this answer solves your problem!<BR />If you need any additional help please <SPAN>@</SPAN> me in your reply.<BR />If my reply provided you with a solution, please consider marking it as a solution <span class="lia-unicode-emoji" title=":heavy_check_mark:">✔️</span> or giving it a kudoe <span class="lia-unicode-emoji" title=":thumbs_up:">👍</span><BR /><BR />Thanks!<BR />Best regards,<BR />Joao Ribeiro</P> Wed, 05 Apr 2023 08:48:43 GMT https://community.fabric.microsoft.com/t5/Developer/line-chart-with-data-pairing/m-p/3173343#M42079 joaoribeiro 2023-04-05T08:48:43Z Re: line chart with data pairing https://community.fabric.microsoft.com/t5/Developer/line-chart-with-data-pairing/m-p/3175498#M42089 <P>many thanks!</P> Thu, 06 Apr 2023 08:35:45 GMT https://community.fabric.microsoft.com/t5/Developer/line-chart-with-data-pairing/m-p/3175498#M42089 Anonymous 2023-04-06T08:35:45Z