Forum Discussion

mabdurrashid's avatar
mabdurrashid
Regular Visitor
8 years ago
Solved

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 sho...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    mabdurrashid,

     

    You may use the following formula.

    Column =
MAX ( Table1[Column2] ) - Table1[Column2]
    + MIN ( Table1[Column2] )
parry2k's avatar
parry2k
Super User
8 years ago

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's avatar
mabdurrashid
Regular Visitor
8 years ago

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