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.
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.