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: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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,214 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,202 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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