Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |