power bi year over year comparison and line chart

Question

I want a custom table/matrix in power bi displaying the year over year data and also a line chart displaying the same. i have all the year information in one column i.e both 2018 and 2019 data in one column. I want to perform an aggregate operation on another column and make the comparison for each of the month in the previous year

The checkout date column has all the date information for both years. The caring attitude column has the data for which i want to perform aggregation based on month

This is how i want the data to be displayed in the power bi

This is the line chart i want. Year over Year comparison of those values

In Excel I manually add the goal values in the rows and then create a graph

Answer 1

*for the former you just need to have date(years) as your rows date(months) as columns and caring attitude of staff as your values(this need to be done in a matrix visual and date should have hierarchy). * for the latter date(months) as axis, date(years) as legend and caring attitude of staff as your values(for line chart).