Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
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:
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.
Solved! Go to Solution.
@mkranitz Could you show how your data set looks?
If you had ticket numbers as a field and you can add another field called Year and month from the date column you might have .. so it would look like this..
So you could create a new column in your table and type the DAX as follows:
YEAR = year(Table[Date]) and
MONTH = Month (Table[Date]) to look as the above screenshot
And then you could choose any bargraph type you want in Power BI ( I have just put multiple types for the same data for more visual options!)
@mkranitz Could you show how your data set looks?
If you had ticket numbers as a field and you can add another field called Year and month from the date column you might have .. so it would look like this..
So you could create a new column in your table and type the DAX as follows:
YEAR = year(Table[Date]) and
MONTH = Month (Table[Date]) to look as the above screenshot
And then you could choose any bargraph type you want in Power BI ( I have just put multiple types for the same data for more visual options!)
YES!
Your guidance got me where I needed to go
The stuff I learned while trying to figure out how to do what you suggested was especially helpful!
MANY THANKS 🙂
Hi Akshaya,
Thank you for your response - it makes perfect sense.
Following are the relevant fields from the table named "Tickets"
A little wrangling and I think I got it! 🙂 🙂
THANK YOU 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |