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 all,
I'm so new to Power BI that I don't even know if the following is easy or hard, but I know I'm stuck! I'm doing the edX course but I'm not ready for this.
I have a table of time intervals that cover a calendar year. Here's a sample.
I want to visualise how often each minute of the day appears in an interval, regardless of the date. So I'd like to make a graph with the minutes of the day from 00:00 to 23:59 along the X axis. There will be 1440 ticks (24 hours by 60 minutes.)
On the Y axis I want to show the number of intervals in which that minute of the day is included (ignoring date).
In SQL I could make a lookup table with all the minutes of the day, then populate it with the appropriate counts but I suspect there's a much slicker way of doing this in Power BI. Can anyone help please? Thanks.
Refer
https://community.powerbi.com/t5/Desktop/Create-Calendar-Table-with-row-per-minute/td-p/192864
Thanks, that nudged me forward. I'm stuck on the the hard bit now! 😀
I'm trying to add a measure to my new Minute table to count the Intervals that contain the Minute. It's a head-scratcher... 🙂
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 |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |