How to filter and visualize data using date, hour, and minute bins in a timestamp format?

[Prachi_Mahajan]

Hi everyone,

I have a dataset with event timestamps, latency, and throughput. The timestamps are in the format yyyy-mm-dd hh:mm:ss. I want to create three slicers for filtering the data:

1. Date Range: Select a range of dates.
2. Hour Range: Select hours from 0 to 23.
3. Minute Bin: Select minute bins (0-15, 15-30, 30-45, 45-00).

For example, if I select the date range from 2025-04-09 to 2025-04-10, hour range from 0 to 5, and minute bin 15, I want to filter the data to include all events from April 9th, 0:00 to April 10th, 5:00, in 15-minute intervals.

Additionally, I want to display this filtered data in a bar chart, showing throughput and latency for the given date-time range.

Could anyone guide me on how to implement these slicers and create the bar chart effectively? Any help or examples would be greatly appreciated!

Thanks in advance!

[Akash_Varuna · Accepted solution]

@Prachi_Mahajan For this, start by creating a Date Range Slicer using Power BI’s default Date Slicer with your timestamp column as DateTime. Then, create a calculated column for Hour Range with Hour = HOUR('TableName'[Timestamp]) and use it as a slicer. For the Minute Bin, create a calculated column that groups minutes into bins like 0-15, 15-30 using a SWITCH function. Finally, add a bar chart with Timestamp on the X-axis and Throughput/Latency on the Y-axis, applying the slicers for filtering.

[v-pnaroju-msft]

Hi Prachi_Mahajan,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi Prachi_Mahajan,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Hi Prachi_Mahajan,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thankyou, @Akash_Varuna, for your response.

Hi @Prachi_Mahajan,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

Please find attached the screenshot and PBIX file, which may help in resolving the issue:

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members who may have similar queries.

Thank you.

[Akash_Varuna · Accepted solution]

@Prachi_Mahajan For this, start by creating a Date Range Slicer using Power BI’s default Date Slicer with your timestamp column as DateTime. Then, create a calculated column for Hour Range with Hour = HOUR('TableName'[Timestamp]) and use it as a slicer. For the Minute Bin, create a calculated column that groups minutes into bins like 0-15, 15-30 using a SWITCH function. Finally, add a bar chart with Timestamp on the X-axis and Throughput/Latency on the Y-axis, applying the slicers for filtering.