Change color depend a value

Understand the code
Post Reply
Danes01
Posts: 1
Joined: November 20th, 2019, 7:19 pm

November 21st, 2019, 1:50 pm

Hello community, at some time of the year I make infographics that show the level of compliance with all types of indicators from different areas of the company.
These are some of the graphic styles that I handle.
https://community.microstrategy.com/s/a ... age=en_US

  Depending on the level of compliance, a color is assigned.
1) 90-100 Green 00FF06
2) 75-89 light green B3EB13
3) 65-74 Wellow FFCB17
4) 51-64 Orange FF5108
5) 0-50 Red C20704

I want the color of the shape to change depending on the value of the slider control, I don't know much about expressions but I have seen that they use "if" and "else" to condition properties - color is not a transformation property but you understand me - and If anyone knows how it can be done, I would greatly appreciate it.
and with those who would like to save me time. Thanks and a hug.
Post Reply