Heatmap of building layout through time

[Slacey7]

Hi All!

I'm looking to create a heatmap of a building layout that visualizes counts through time. 

I'd greatly appreciate a point in the right direction of how to create what I'm looking for which is detailed below. 

• Additionally, I've detailed some of what I've tried, and why it's not working. 

The goal would be for it to look something like this. 

With a play Axis similar to the scatter chart - like this. 

The layout of the building is similar to this. 

• In the building there are: 
  • 8 houses. 
  • Each house has pods (A-Z)
  • Within each Pod there are 'bins' (1 to 100)

The data set looks like this. 

Matrix Example: 

• I can somewhat create what I want.
• Pros & Cons:
  • Cons: It's impossible to create the visual with the exact layout of houses, pods and bins
    • Especially at scale with multiple 'buildings' having different layouts of houses, pods, bins. 
  • Using the data "between" slicer is closest to what I want. 
    • Pros: Can slide the date. 
    • Cons: It always needs to be 1 day at a time.  

Using the imported "Heat Streams" Visual

• It does parts of what I want. 
• Pros & Cons
  • Cons:
    • it doesn't seprate out rows and columns
    • Doesn't allow you to see subcategories within a category (i.e. bins within pods.)
    • It shows all the time categories at once, instead of 1 day at a time. 
  • Pros: Closer to the type of heatmapping I'm looking for. 

Play Axis similar to Scatter Chart is ideal

A Scatter chart won't work

• The ideal way of visualizing the desired heat map through time would be using a play axis similar to the one on the scatter chart. 

Thank you for any suggestions!

[MFelix]

Hi @Slacey7 ,

If you want to have the exact layout of the buildings maybe you should use the synoptic panel that allows to pick up svg images and make then a visual it self

https://okviz.com/synoptic-panel/

https://synoptic.design/

https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380873?tab=overview (includes an example PBIX file)

[Slacey7]

Thanks @MFelix 

I've gone with your suggestion for a high level vew of the facilities. 

• Additionally, I was able to figure out a heatmap using the matrix for when you click into a specific room.

The challenge I'm finding at this point is the performance of the visual display can get pretty slow.

• My DAX is fine, executing areound ~5ms.
• The visual dispays can take up to 1500ms to refresh.  

So, instead of having a very granular matrix of the entire facility, I've opted for your solution for a high level view, and then when clicking into a house I only need a 6 x 9 matric to update of any given house. Where, I require a 40 x 72 matrix of the entire facility before - which gets slow with conditional formatting and such.