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.
I have searched for a while but only have found solutions using start and end times and recreating those solutions has not worked.
What I am looking for is to create a table that on one axis has day and the other axis has time intervals (30 mins) so I can display the number of tickets in each 30 minute interval for every day in a given month. Creating bins using the built in feature carries the date along with it so I end up with a massive table that shows the date with every time interval. I am just looking to have 30 minute bin vs day.
To be a little more clear, the field I am trying to convert is a date + time field. I am using that date + time field twice on the same matrix. One axis being the day of that date time field, the other axis being a 30 minute interval bin of that date time field. While the values are just a count of tickets.
Any solutions?
Solved! Go to Solution.
I was able to get this to work simply by splitting by date time field into date and time seperately then using the group/bin function on just the time field.
I was able to get this to work simply by splitting by date time field into date and time seperately then using the group/bin function on just the time field.
@trevordunham Seems like a variation on Open Tickets. If you can post sample data, could be more specific.
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
This is one of the solutions I came across that I mentioned involves open and close times. I was unable to use this as a solution.
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 |
---|---|
113 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |