Forum Discussion
Line chart not populating correctly
Hi Team
I am working with the below data.
I need to create a line chart that shows the 'PremiumTot' over the period.
When I add the MonthYear to the X axis, and the PremiumTot to the Y axis, the line chart produces as per the below.
My issue is that the line graph seems to be adding the figures from the 2022 and 2023 month together. I.e. 550,582 (January 2022) + 518,784 (January 2023).
Could you please help me to format the line chart so that the X axis displays month on month i.e. January 2022 as 550,582, February 2022 as 547,103, March 2022 as 544,615 and so on?
Thank you!
MBF38 are you using an in-built hierarch to drill down to the months?
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence Playlist
2 Replies
- parry2k
Super User
MBF38 are you using an in-built hierarch to drill down to the months?
As a best practice, add a date dimension in your model and use it for time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools. Check the related videos on my YT channel
Add Date Dimension
Importance of Date Dimension
Mark date dimension as a date table - why and how?
Time Intelligence PlaylistThank you - your answer was very helpful!
