How to solve this one

[gopichilla]

I want sales ranges in colors like below

sales between 60% to 100% - green

sales between 35% to 59% -yellow

sales below 35% -red

 Thanks

[gopichilla · Accepted solution]

Thanks for quick response. 

I got a solution for my question below is my solution

Sales Range = IF(Sales[Sales]<1000,"low",IF(Sales[Sales]<3000,"medium","high"))  

[Greg_Deckler]

% of what, or are those like 1,519.9% (first one)?

[gopichilla · Accepted solution]

Thanks for quick response. 

I got a solution for my question below is my solution

Sales Range = IF(Sales[Sales]<1000,"low",IF(Sales[Sales]<3000,"medium","high"))  

[Greg_Deckler · Accepted solution]

Yep, that will work!