Hello,
I have to different excel workbooks uploaded into power BI desktop. The first excel workbook has entries from 2017 to 2019. The second workbook has two entries from 2019 and the rest are 2020 (this is a workbook that keeps updating with new data on 2020). I want to create a graph that shows month by month the number of entries created (count of) in 2019 and the ones created so far for 2020. Then I would like to show YTD of current/actual and previous year on the same graph and the target line. Any idea how to make this? I'm pretty new to Power BI desktop but I'm able to create this type of graphs in excel. Right now I am using line and clustered column chart but when I separate by month the file that contains entries from 2019 and 2020 gives me the total entries created as of today, not by month.
Thank you.
I have to different excel workbooks uploaded into power BI desktop. The first excel workbook has entries from 2017 to 2019. The second workbook has two entries from 2019 and the rest are 2020 (this is a workbook that keeps updating with new data on 2020). I want to create a graph that shows month by month the number of entries created (count of) in 2019 and the ones created so far for 2020. Then I would like to show YTD of current/actual and previous year on the same graph and the target line. Any idea how to make this? I'm pretty new to Power BI desktop but I'm able to create this type of graphs in excel. Right now I am using line and clustered column chart but when I separate by month the file that contains entries from 2019 and 2020 gives me the total entries created as of today, not by month.
Thank you.
