Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
rayb
New Member

Heat Streams Custom Visual Struggle

‎10-04-2017 01:25 PM

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

 

 

selected image

 

 

 

Use Reason Codes to identify causes of the Six Big Losses

 

 

 

MachineID ObservationTime MachineStateID

2018:00:00 AM5
2008:00:00 AM5
2028:00:00 AM5
2128:00:00 AM5
2118:00:00 AM2
2108:00:00 AM5
2118:00:30 AM2
2018:00:30 AM5
2008:00:30 AM5
2028:00:30 AM5
2108:00:30 AM5
2128:00:30 AM5
2118:01:00 AM2
2128:01:00 AM5
2028:01:00 AM5
2008:01:00 AM5
2018:01:00 AM5
2108:01:00 AM5
2018:01:30 AM5
2008:01:30 AM5
2108:01:30 AM5
2128:01:30 AM5
2118:01:30 AM2
2028:01:30 AM5
2108:02:00 AM5
2118:02:00 AM2
2028:02:00 AM5
2018:02:00 AM5
2008:02:00 AM5
2128:02:00 AM5
2028:02:30 AM5
2018:02:30 AM5
2108:02:30 AM5
2118:02:30 AM2
2008:02:30 AM5
2128:02:30 AM5
2118:03:00 AM2
2128:03:00 AM5
2028:03:00 AM5
2008:03:00 AM5
2018:03:00 AM5
2108:03:00 AM5
2018:03:30 AM5
2008:03:30 AM5
2108:03:30 AM5
2128:03:30 AM5
2118:03:30 AM2
2028:03:30 AM5
2108:04:00 AM5
2118:04:00 AM2
2028:04:00 AM5
2018:04:00 AM5
2008:04:00 AM5
2128:04:00 AM5
2128:04:30 AM5
2008:04:30 AM5
2118:04:30 AM2
2018:04:30 AM5
2108:04:30 AM5
2028:04:30 AM5
2028:05:00 AM5
2018:05:00 AM5
2108:05:00 AM5
2128:05:00 AM5
2118:05:00 AM2
2008:05:00 AM5
2018:05:30 AM5
2128:05:30 AM5
2028:05:30 AM5
2118:05:30 AM2
2108:05:30 AM5
2008:05:30 AM5
2108:06:00 AM5
2118:06:00 AM2
2018:06:00 AM5
2008:06:00 AM5
2028:06:00 AM5
2128:06:00 AM5
2028:06:30 AM5
2018:06:30 AM5
2118:06:30 AM2
2128:06:30 AM5
2008:06:30 AM5
2108:06:30 AM5
2118:07:00 AM2
2128:07:00 AM5
2018:07:00 AM5
2028:07:00 AM5
2108:07:00 AM5
2008:07:00 AM5
2028:07:30 AM5
2008:07:30 AM5
2018:07:30 AM5
2108:07:30 AM5
2128:07:30 AM5
2118:07:30 AM2
2118:08:00 AM2
2028:08:00 AM5
2108:08:00 AM5
2008:08:00 AM5
2018:08:00 AM5
2128:08:00 AM5
2008:08:30 AM5
2118:08:30 AM2
2108:08:30 AM5
2018:08:30 AM5
2128:08:30 AM5
2028:08:30 AM5
2118:09:00 AM2
2018:09:00 AM5
2028:09:00 AM5
2108:09:00 AM5
2008:09:00 AM5
2128:09:00 AM5
2028:09:30 AM5
2018:09:30 AM5
2108:09:30 AM5
2008:09:30 AM5
2118:09:30 AM2
2128:09:30 AM5
2108:10:00 AM5
2118:10:00 AM2
2028:10:00 AM5
2008:10:00 AM5
2018:10:00 AM5
2128:10:00 AM5
Labels:
Message 1 of 2
1,222 Views
0
1 REPLY 1
Anonymous
Not applicable

‎10-05-2017 11:36 PM

@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.
1.JPG

Regards,
Lydia

Message 2 of 2
1,210 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

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.

View All