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] )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

mabdurrashid,

 

You may use the following formula.

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

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