topic Re: Understanding the Line Y-Axis in Developer https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3752167#M50238 <P>Add the bag color column as a filter on the visual, the page, or the report.</P> Fri, 08 Mar 2024 22:43:18 GMT lbendlin 2024-03-08T22:43:18Z Understanding the Line Y-Axis https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3751295#M50224 <P>I am recreating a chart which shows total number of clients per month - within the Y-Axis, I want to pull in those clients who bought for example a red bag. So I have selected Line and Clustered Chart.</P><P>&nbsp;</P><P>X-Axis - Sales Month</P><P>Y-Axis - Count of how many sales</P><P>&nbsp;</P><P>This is ok.</P><P>&nbsp;</P><P>But using the Line Y-axis - is pulling a total number of each month but Id like that total to only be for 'red bags'. Could someone please kindly tell me how I can achieve this?thanks</P> Fri, 08 Mar 2024 11:37:59 GMT https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3751295#M50224 Anonymous 2024-03-08T11:37:59Z Re: Understanding the Line Y-Axis https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3752167#M50238 <P>Add the bag color column as a filter on the visual, the page, or the report.</P> Fri, 08 Mar 2024 22:43:18 GMT https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3752167#M50238 lbendlin 2024-03-08T22:43:18Z Re: Understanding the Line Y-Axis https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3754045#M50282 <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Hi @Anonymous</a>&nbsp;,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test.</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;"><A href="http://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490" target="_blank" rel="noopener">How to Get Your Question Answered Quickly&nbsp;</A>&nbsp;</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Regards,</P> <P style="margin: 0in; font-family: tahoma; font-size: 11.0pt;">Xiaoxin Sheng</P> Mon, 11 Mar 2024 05:57:03 GMT https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3754045#M50282 Anonymous 2024-03-11T05:57:03Z Re: Understanding the Line Y-Axis https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3757264#M50337 <P>So in the columns I have total sales per month - but on the line I want to highlight a certain item sold but its pulling total numbers here&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Jane3999_0-1710229516389.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1058348iDFC5757E151F068F/image-size/medium?v=v2&amp;px=400" role="button" title="Jane3999_0-1710229516389.png" alt="Jane3999_0-1710229516389.png" /></span></P><P>&nbsp;</P> Tue, 12 Mar 2024 07:45:45 GMT https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3757264#M50337 Anonymous 2024-03-12T07:45:45Z Re: Understanding the Line Y-Axis https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3757888#M50351 <P>Please provide sample data that covers your issue or question <STRONG>completely</STRONG>, in a <STRONG>usable</STRONG> format (not as a screenshot).<BR /><BR />Do not include sensitive information or anything not related to the issue or question. <BR /><BR />If you are unsure how to upload data please refer to <A href="https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR /><BR />Please show the expected outcome based on the sample data you provided. <BR /><BR />Want faster answers? <A href="https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Tue, 12 Mar 2024 12:19:33 GMT https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3757888#M50351 lbendlin 2024-03-12T12:19:33Z Re: Understanding the Line Y-Axis https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3757983#M50354 <P>&nbsp;So, id like the columns to prepresent the total sales each month. So 27 in total for june and 24 for july. Id like the line to only show red bags. So this would be 9 for june and 8 for july. Does that make sense? Am I using the wrong visual ?thank you</P><TABLE border="1"><TBODY><TR><TD>Sales</TD><TD>month</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/06/2024</TD></TR><TR><TD>blue bag</TD><TD>01/06/2024</TD></TR><TR><TD>purple bags</TD><TD>01/06/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/06/2024</TD></TR><TR><TD>blue bag</TD><TD>01/06/2024</TD></TR><TR><TD>purple bags</TD><TD>01/06/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/06/2024</TD></TR><TR><TD>blue bag</TD><TD>01/06/2024</TD></TR><TR><TD>purple bags</TD><TD>01/06/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/06/2024</TD></TR><TR><TD>blue bag</TD><TD>01/06/2024</TD></TR><TR><TD>purple bags</TD><TD>01/06/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/07/2024</TD></TR><TR><TD>blue bag</TD><TD>01/07/2024</TD></TR><TR><TD>purple bags</TD><TD>01/07/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/07/2024</TD></TR><TR><TD>blue bag</TD><TD>01/07/2024</TD></TR><TR><TD>purple bags</TD><TD>01/07/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/07/2024</TD></TR><TR><TD>blue bag</TD><TD>01/07/2024</TD></TR><TR><TD>purple bags</TD><TD>01/07/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/07/2024</TD></TR><TR><TD>blue bag</TD><TD>01/07/2024</TD></TR><TR><TD>purple bags</TD><TD>01/07/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/07/2024</TD></TR><TR><TD>blue bag</TD><TD>01/07/2024</TD></TR><TR><TD>purple bags</TD><TD>01/07/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/07/2024</TD></TR><TR><TD>blue bag</TD><TD>01/07/2024</TD></TR><TR><TD>purple bags</TD><TD>01/07/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/07/2024</TD></TR><TR><TD>blue bag</TD><TD>01/07/2024</TD></TR><TR><TD>purple bags</TD><TD>01/07/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/07/2024</TD></TR><TR><TD>blue bag</TD><TD>01/07/2024</TD></TR><TR><TD>purple bags</TD><TD>01/07/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/06/2024</TD></TR><TR><TD>blue bag</TD><TD>01/06/2024</TD></TR><TR><TD>purple bags</TD><TD>01/06/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/06/2024</TD></TR><TR><TD>blue bag</TD><TD>01/06/2024</TD></TR><TR><TD>purple bags</TD><TD>01/06/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/06/2024</TD></TR><TR><TD>blue bag</TD><TD>01/06/2024</TD></TR><TR><TD>purple bags</TD><TD>01/06/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/06/2024</TD></TR><TR><TD>blue bag</TD><TD>01/06/2024</TD></TR><TR><TD>purple bags</TD><TD>01/06/2024</TD></TR><TR><TD>red bags&nbsp;</TD><TD>01/06/2024</TD></TR><TR><TD>blue bag</TD><TD>01/06/2024</TD></TR><TR><TD>purple bags</TD><TD>01/06/2024</TD></TR></TBODY></TABLE> Tue, 12 Mar 2024 12:56:49 GMT https://community.fabric.microsoft.com/t5/Developer/Understanding-the-Line-Y-Axis/m-p/3757983#M50354 Anonymous 2024-03-12T12:56:49Z