globe map heat intensity

[mabdurrashid]

Hi,

I am using Globe Map to show heatmap intensity in reverse with lower numbers producing higher intensity.  Using it for capacity constraints at various locations, so want lower capacity to show more intense heat.

Would also want to do the same for ArcGIS heat map style.

[v-chuncz-msft · Accepted solution]

@mabdurrashid,

You may use the following formula.

Column =
MAX ( Table1[Column2] ) - Table1[Column2]
    + MIN ( Table1[Column2] )

[parry2k]

when I tried negative value at my end, it did worked and intensity was switched as expected. 

[mabdurrashid]

I should have asked if anyone knows how to have the heat intensity map reflect having greater intensity for lower values.

[parry2k]

may be add new column with - (negative) in front of the value and use that for intensity.

new column for intensity = -Table1[my Column]

[mabdurrashid]

Thanks Parry2K, I tried it but the heat map does not show.  Seems as if it does not show negative numbers.