Forum Discussion

Prachi_Mahajan's avatar
Prachi_Mahajan
New Member
1 year ago
Solved

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

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: Date Rang...
  • Akash_Varuna's avatar
    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.

  • v-pnaroju-msft's avatar
    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.