Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
I was able to solve this issue by formatting the data in my table as a number
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.
I was able to solve this issue by formatting the data in my table as a number
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |