Forum Discussion

gopichilla's avatar
gopichilla
Icon for Resolver III rankResolver III
9 years ago
Solved

How to solve this one

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

 

Need Help
  • gopichilla's avatar
    gopichilla
    9 years ago

    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"))  

3 Replies

    • gopichilla's avatar
      gopichilla
      Icon for Resolver III rankResolver III
      9 years ago

      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"))