Forum Discussion
Multiyear in X-axis Multiline Time Series chart
Dear all,
I have the following data table which basically continues using those same three columns (Country Name, Total Bank Deposits, Year) providing data for 25 countries for the years 2015-2023.
The column 'Year' is formatted as an integer and not as a date (to avoid having each year turn to 1905). 'Total Deposits' is formatted as a decimal (but if need be I can turn it into an integer since my research does not focus on small, decimal-related differences) and 'Country Name' is a text column. I am trying to create a line chart where the y-axis will show the Total Deposits, the x-axis will show the years and each line will be of a different color and correspond to each country like the following :
So far Power BI keeps counting the years and presenting with the chart below :
Any ideas on how I can achieve it are highly appreciated.
Thanks a lot
Check your data model again, seems to be insufficiently wired.
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/1447523Hi PowerNewbieGR_1 ,
Please check that the y-axis field is set to sum aggregation mode.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- lbendlin
Super User
Check your data model again, seems to be insufficiently wired.
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/1447523Both of the posts are really helpful. I 'll try to follow them
Thanks Idendlin
Hi PowerNewbieGR_1 ,
Please check that the y-axis field is set to sum aggregation mode.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks a lot v-tangjie-msft. It certainly had the effect I was looking for.
