Forum Discussion

BI3N's avatar
BI3N
Frequent Visitor
7 years ago

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,...
Need Help
jtownsend21's avatar
jtownsend21
Responsive Resident
7 years ago

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.