Heat map get scrumbled and I don't know why

[sracer2017]

Hi,

Here are symptoms, knowing that I cleanded data and columns are of type Decimal:

Sometimes one cell is drawn in the same level of headers,

Colors are being changed when I add a line or a column,

Any help would be very appreciated.

Thanks in advance,

[v-jiascu-msft]

Hi @sracer2017,

Could you please mark the proper answer if it's convenient for you? That will be a help to others.

Best Regards!
Dale

[sracer2017]

Hi v-jiascu-msft !

I express my excuses for not following the issue here, one reason is that I forgot, and also I havn't seen your first message.

The visual was Table Heatmap, proposed for public here. The issue is the following: It happens that Table Heatmap doesn't deal with zeros, for that I've been adding small value: 0.01 and problem was solved.

That was my only solution.

Regards.

[sracer2017]

I will not mark my respose as a solution, I will wait for other possible solutions.

[v-jiascu-msft · Accepted solution]

Hi @sracer2017,

I have tested this visual. It deals with 0 but not blanks. This makes sense. Please change the blank fields of the numerical column into 0s. If you satisfy this solution, please mark it as answer.

Best Regards!

Dale

[v-jiascu-msft]

Hi @sracer2017,

Could you please tell me which "Heat map" you are using? In "ArcGIS" visual, I can't find a line or column. Could you please post some snapshot?

Best Regards!

Dale