Stacked Column Chart with 15min time increments

[JeremyM]

Hi,

New to Power Bi. I am trying to graph the number of occurrances (rows) per 15min interval. 

Sample data:

ID	DEVICEID	CREATED_AT
1801784561	4955	2021-09-16 14:36:09
1801783781	4955	2021-09-16 14:35:58
1801782516	4955	2021-09-16 14:35:41
1801781741	4954	2021-09-16 14:35:30
1801780808	4954	2021-09-16 14:35:18
1801780750	4955	2021-09-16 14:35:17
1801779698	4955	2021-09-16 14:35:02
1801778223	4954	2021-09-16 14:34:42
1801777219	4955	2021-09-16 14:34:29
1801776515	4954	2021-09-16 14:34:19

Obviously this data is continuous over hours/days/weeks etc.

If I set a date range of 5 days I'd like to see a graph plotted showing the number of transactions per 15 minute period over the full 5 days.

Much appreciated.

[selimovd · Accepted solution]

Hey @JeremyM ,

add a date dimension and a time dimension with 15 minute buckets to your data model:

PowerBISnippets/Time table with buckets in M.txt at main · selimovd/PowerBISnippets (github.com)

Then you can connect both to your fact table and then calculate the amount per date and bucket.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic