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

[Anonymous]

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

[v-xuding-msft]

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 · Accepted solution]

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