Forum Discussion
globe map heat intensity
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.
You may use the following formula.
Column = MAX ( Table1[Column2] ) - Table1[Column2] + MIN ( Table1[Column2] )
5 Replies
- mabdurrashidRegular Visitor
I should have asked if anyone knows how to have the heat intensity map reflect having greater intensity for lower values.
- parry2kSuper User
may be add new column with - (negative) in front of the value and use that for intensity.
new column for intensity = -Table1[my Column]
- mabdurrashidRegular Visitor
Thanks Parry2K, I tried it but the heat map does not show. Seems as if it does not show negative numbers.
- v-chuncz-msftCommunity Support
You may use the following formula.
Column = MAX ( Table1[Column2] ) - Table1[Column2] + MIN ( Table1[Column2] )- parry2kSuper User
when I tried negative value at my end, it did worked and intensity was switched as expected.