Hi All,
I am struggling with the Heat Streams Custom Visual add-in. I have a time series set of data that records the current state of a machine every 30 seconds. Sample data layout is below. I struggled with the count/sum issue for a while but eventually figured the issue out with help from this forum. Then I discovered the Custom Visual is only granular to the hourly level. Therefore all the incremental 30 second data points are aggregated together and the result is 8 color blocks and not 960 in an eight hour shift. I have pasted a copy of the visual example from the Heat Streams add-in page for reference as well as an example of what I am trying to achieve.
How do I structure a query that will allow me to use the Heat Stream Custom Visual or is there a better visual that I am not aware of?
Thanks,
Ray
MachineID ObservationTime MachineStateID
| 201 | 8:00:00 AM | 5 |
| 200 | 8:00:00 AM | 5 |
| 202 | 8:00:00 AM | 5 |
| 212 | 8:00:00 AM | 5 |
| 211 | 8:00:00 AM | 2 |
| 210 | 8:00:00 AM | 5 |
| 211 | 8:00:30 AM | 2 |
| 201 | 8:00:30 AM | 5 |
| 200 | 8:00:30 AM | 5 |
| 202 | 8:00:30 AM | 5 |
| 210 | 8:00:30 AM | 5 |
| 212 | 8:00:30 AM | 5 |
| 211 | 8:01:00 AM | 2 |
| 212 | 8:01:00 AM | 5 |
| 202 | 8:01:00 AM | 5 |
| 200 | 8:01:00 AM | 5 |
| 201 | 8:01:00 AM | 5 |
| 210 | 8:01:00 AM | 5 |
| 201 | 8:01:30 AM | 5 |
| 200 | 8:01:30 AM | 5 |
| 210 | 8:01:30 AM | 5 |
| 212 | 8:01:30 AM | 5 |
| 211 | 8:01:30 AM | 2 |
| 202 | 8:01:30 AM | 5 |
| 210 | 8:02:00 AM | 5 |
| 211 | 8:02:00 AM | 2 |
| 202 | 8:02:00 AM | 5 |
| 201 | 8:02:00 AM | 5 |
| 200 | 8:02:00 AM | 5 |
| 212 | 8:02:00 AM | 5 |
| 202 | 8:02:30 AM | 5 |
| 201 | 8:02:30 AM | 5 |
| 210 | 8:02:30 AM | 5 |
| 211 | 8:02:30 AM | 2 |
| 200 | 8:02:30 AM | 5 |
| 212 | 8:02:30 AM | 5 |
| 211 | 8:03:00 AM | 2 |
| 212 | 8:03:00 AM | 5 |
| 202 | 8:03:00 AM | 5 |
| 200 | 8:03:00 AM | 5 |
| 201 | 8:03:00 AM | 5 |
| 210 | 8:03:00 AM | 5 |
| 201 | 8:03:30 AM | 5 |
| 200 | 8:03:30 AM | 5 |
| 210 | 8:03:30 AM | 5 |
| 212 | 8:03:30 AM | 5 |
| 211 | 8:03:30 AM | 2 |
| 202 | 8:03:30 AM | 5 |
| 210 | 8:04:00 AM | 5 |
| 211 | 8:04:00 AM | 2 |
| 202 | 8:04:00 AM | 5 |
| 201 | 8:04:00 AM | 5 |
| 200 | 8:04:00 AM | 5 |
| 212 | 8:04:00 AM | 5 |
| 212 | 8:04:30 AM | 5 |
| 200 | 8:04:30 AM | 5 |
| 211 | 8:04:30 AM | 2 |
| 201 | 8:04:30 AM | 5 |
| 210 | 8:04:30 AM | 5 |
| 202 | 8:04:30 AM | 5 |
| 202 | 8:05:00 AM | 5 |
| 201 | 8:05:00 AM | 5 |
| 210 | 8:05:00 AM | 5 |
| 212 | 8:05:00 AM | 5 |
| 211 | 8:05:00 AM | 2 |
| 200 | 8:05:00 AM | 5 |
| 201 | 8:05:30 AM | 5 |
| 212 | 8:05:30 AM | 5 |
| 202 | 8:05:30 AM | 5 |
| 211 | 8:05:30 AM | 2 |
| 210 | 8:05:30 AM | 5 |
| 200 | 8:05:30 AM | 5 |
| 210 | 8:06:00 AM | 5 |
| 211 | 8:06:00 AM | 2 |
| 201 | 8:06:00 AM | 5 |
| 200 | 8:06:00 AM | 5 |
| 202 | 8:06:00 AM | 5 |
| 212 | 8:06:00 AM | 5 |
| 202 | 8:06:30 AM | 5 |
| 201 | 8:06:30 AM | 5 |
| 211 | 8:06:30 AM | 2 |
| 212 | 8:06:30 AM | 5 |
| 200 | 8:06:30 AM | 5 |
| 210 | 8:06:30 AM | 5 |
| 211 | 8:07:00 AM | 2 |
| 212 | 8:07:00 AM | 5 |
| 201 | 8:07:00 AM | 5 |
| 202 | 8:07:00 AM | 5 |
| 210 | 8:07:00 AM | 5 |
| 200 | 8:07:00 AM | 5 |
| 202 | 8:07:30 AM | 5 |
| 200 | 8:07:30 AM | 5 |
| 201 | 8:07:30 AM | 5 |
| 210 | 8:07:30 AM | 5 |
| 212 | 8:07:30 AM | 5 |
| 211 | 8:07:30 AM | 2 |
| 211 | 8:08:00 AM | 2 |
| 202 | 8:08:00 AM | 5 |
| 210 | 8:08:00 AM | 5 |
| 200 | 8:08:00 AM | 5 |
| 201 | 8:08:00 AM | 5 |
| 212 | 8:08:00 AM | 5 |
| 200 | 8:08:30 AM | 5 |
| 211 | 8:08:30 AM | 2 |
| 210 | 8:08:30 AM | 5 |
| 201 | 8:08:30 AM | 5 |
| 212 | 8:08:30 AM | 5 |
| 202 | 8:08:30 AM | 5 |
| 211 | 8:09:00 AM | 2 |
| 201 | 8:09:00 AM | 5 |
| 202 | 8:09:00 AM | 5 |
| 210 | 8:09:00 AM | 5 |
| 200 | 8:09:00 AM | 5 |
| 212 | 8:09:00 AM | 5 |
| 202 | 8:09:30 AM | 5 |
| 201 | 8:09:30 AM | 5 |
| 210 | 8:09:30 AM | 5 |
| 200 | 8:09:30 AM | 5 |
| 211 | 8:09:30 AM | 2 |
| 212 | 8:09:30 AM | 5 |
| 210 | 8:10:00 AM | 5 |
| 211 | 8:10:00 AM | 2 |
| 202 | 8:10:00 AM | 5 |
| 200 | 8:10:00 AM | 5 |
| 201 | 8:10:00 AM | 5 |
| 212 | 8:10:00 AM | 5 |
@rayb,
Could you please check if the Time Brush Slicer custom visual returns your expected result? If not, you may need to create your own custom visual.
Regards,
Lydia
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
