Understanding the Line Y-Axis

[Anonymous]

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.

X-Axis - Sales Month

Y-Axis - Count of how many sales

This is ok.

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

[Anonymous]

Hi @Anonymous ,

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.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Anonymous]

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 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous]

 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

Sales	month
red bags	01/06/2024
blue bag	01/06/2024
purple bags	01/06/2024
red bags	01/06/2024
blue bag	01/06/2024
purple bags	01/06/2024
red bags	01/06/2024
blue bag	01/06/2024
purple bags	01/06/2024
red bags	01/06/2024
blue bag	01/06/2024
purple bags	01/06/2024
red bags	01/07/2024
blue bag	01/07/2024
purple bags	01/07/2024
red bags	01/07/2024
blue bag	01/07/2024
purple bags	01/07/2024
red bags	01/07/2024
blue bag	01/07/2024
purple bags	01/07/2024
red bags	01/07/2024
blue bag	01/07/2024
purple bags	01/07/2024
red bags	01/07/2024
blue bag	01/07/2024
purple bags	01/07/2024
red bags	01/07/2024
blue bag	01/07/2024
purple bags	01/07/2024
red bags	01/07/2024
blue bag	01/07/2024
purple bags	01/07/2024
red bags	01/07/2024
blue bag	01/07/2024
purple bags	01/07/2024
red bags	01/06/2024
blue bag	01/06/2024
purple bags	01/06/2024
red bags	01/06/2024
blue bag	01/06/2024
purple bags	01/06/2024
red bags	01/06/2024
blue bag	01/06/2024
purple bags	01/06/2024
red bags	01/06/2024
blue bag	01/06/2024
purple bags	01/06/2024
red bags	01/06/2024
blue bag	01/06/2024
purple bags	01/06/2024

[lbendlin]

Add the bag color column as a filter on the visual, the page, or the report.