Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Map data colors conditional formatting color scale only uses count as summarization

I am trying to create a map using conditional formatting for a color scale based on a field that is numerical.

 

When I try to create my format scale, I am only given the option to Count the field.  I would require Max or just the value itself.  Below is what I am seeing along with the field I am basing the formatting on.

 

ScaleData Source

  • Anonymous's avatar
    Anonymous
    7 years ago

    I was able to solve this issue by formatting the data in my table as a number

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support

    Hi Anonymous ,

    By my test, you could try to use "sum" to show the maximum total value. Otherwise, you need to create a measure to get the maximum value firstly, then to set conditional formatting.

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      I was able to solve this issue by formatting the data in my table as a number