Forum Discussion
How to filter and visualize data using date, hour, and minute bins in a timestamp format?
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.
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.
Community SupportHi 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.