Two year data comparison - please help

[BI3N]

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?

[jtownsend21]

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. 

[Anonymous]

Take a look at this post as it talks about how to set this all up:

https://community.powerbi.com/t5/Desktop/Need-help-creating-YTD-and-LYTD-and-make-Index-as-Card/m-p/...

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] ))

[BI3N]

Hi 

Thank you for your reply. 

I have found a different solution. i willl share if anyone needed.