Forum Discussion

maek86's avatar
maek86
Frequent Visitor
9 years ago

ArcGIS Heatmap Measure Formula Calculation

Hello,

 

Has anyone had trouble with a measure that is in a table not displaying correctly in the ArcGIS heat map.

 

You would expect to see the formula 1/4=25%.

 

The formula works fine in matrix view. When I switch to the heatmap the formula is not correct and will display 6%. The color shading is based on the percentage so I would like this to be correct. Has anyone else had this issue?

 

Thanks

Tips and Tricks

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    maek86

     

    What's the fields your put in matrix to slice your measure?

     

    In matrix, the measure is always aggregated on cell level. It should show corresponding data for different areas.

     

    Can you share some screenshots and underlying sample data?

     

    Regards,

    • SamTrexler's avatar
      SamTrexler
      Helper IV
      9 years ago

      I have a similar issue, but not on a heatmap. I am showing a percentage by County for a given state. Coloring the counties works fine, but the tooltip shows an incorrect value. I have determined that it is cutting off the high-order digit of the percentage. For example, 8.52% displays correctly, but 10.73% displays as "0.73%" in the tooltip. Any value over 10% is wrong, for example 23.12% will display as 3.12%, etc.

       

      BTW, I have also described this in the "ArcGIS Maps for Power BI (Preview) Discussion" thread last week, with no response yet. And a variety of searches on these forumes and Google have not turned anything up.

       

      Does anyone have a solution or recommendation?

       

      Thanks,