Forum Discussion
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
- Anonymous7 years ago
I was able to solve this issue by formatting the data in my table as a number
2 Replies
- v-xuding-msftCommunity 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.
- AnonymousNot applicable
I was able to solve this issue by formatting the data in my table as a number