Forum Discussion
Understanding the Line Y-Axis
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
5 Replies
Add the bag color column as a filter on the visual, the page, or the report.
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
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-Forum/ba-p/963216
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/1447523
