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