Shape Map only show data with filter

[wes-shen-poal]

Hi there,

I'm wanting to use Shape Map to show the number of containers stacked on top of each other for a given container slot. The maximum stack is three containers high.

As seen from screenshot below, orange represents slots stacked 2 containers high, and red represents slots stacked 3 containers high. For some reason, slots with only one container is not coloured e.g. for Slot F103G, table on the right first row tells me there's one export container, but when I hover over the slot on shape map, it's not capturing any data...

BUT when I filter the visual by clicking on the EXPRT column on the table, the slots coloured yellow now appears (representing slots with only one container). See screenshot below:

Can this be fixed so that slots with only one container is coloured yellow even when I don't filter anything using the table?

Thanks,

Wes

[v-qiuyu-msft · Accepted solution]

Hi @wes-shen-poal,

In your first image, the left visual contains too much data which can't be display completely. You can click the red section button then you will see the Too many values warning. 

In your scenario, as the waring message suggested, please filter the visual data or choose another field to make all data can display. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi,

I'm not 100% but is it possible that when you click on that column you are now mapping 4 values, blank, 1, 2, and 3. That would explain the sudden change in colour scheme as previously (i assume you were mapping the total column) the only values were 1, 2, 3.

Can you change the colours of each value in the visual through the paintbrush tab?

Best wishes,

Will

[wes-shen-poal]

Hi @Anonymous

Thanks for the input. Even if I map the total column, there should be 0's as some slots are not occupied by any containers at all, so I would assume i'm still mapping 4 values either way.