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