Forum Discussion
Two year data comparison - please help
Hi,
I have data in one single spreadsheet for the year 2017 and 2018 (Adding 2019 later).
I want a line or Bar chart which compares two years of commission data in one visualization.
However, I'm getting the following chart which separates year as below.
ideally, I would want a chart like below.
I'm frustrated as I did two separate spreadsheets as well and it didn't work as X-axis which has months didn't sort accordingly. so I'm trying a single spreadsheet and still cannot solve this issue.
Isn't this basic to data. I can't even find any solution in the community or youtube. Please, can someone help me?
3 Replies
Take a look at this post as it talks about how to set this all up:
But one thing that isnt in that post, is the formula for Total Sales of the last period :
Total Sales Last Period = CALCULATE( [Total Sales], SAMEPERIODLASTYEAR( DimCalendar[Date] ))
Hi
Thank you for your reply.
I have found a different solution. i willl share if anyone needed.
I would create a column for year using the following:
Year = Year(Date)
Then in the date hierarchy just put in month, and put the year in on the legend.
If the months are not sorting properly, you can create a column for the month number using the following:
MonthNumber = FORMAT( [Date], "M" )And then use the Sort by Column fuction on the modeling tab. (shortcut ALT, M, S) and sort by the new Month Number column.
