I'm still a noob, and have looked through the forums and can't seem to find out how to do something you guys will think is relatively simple!
I'm trying to create a graph that shows each month of the year along the x axis. The Y axis will show a count of tickets.
I want to know how to create stacked column chart that shows the number of tickets last year vs tickets this year for each month.
I have a single table that I export from an application. The table has two values that I would use for this:
Ticket, which is the ticket number
Entered, which is the date the ticket was entered
I think I need to create a measure or something that shows all 2018 tickets, and another measure that shows all 2019 tickets and then add them both to the value field of a power bi object, but I haven't been able to crack it!
I basically want the following table but instead of $, I want a count of tickets by month for each year.