Forum Discussion

cmajewski's avatar
cmajewski
Frequent Visitor
7 years ago
Solved

Conditional Formatting Quesiton

I noticed in the May 2018 Update of Power BI they changed conditional formatting and added some powerful new features. I should get this menu:   But instead I get this:   I am runnin...
Tutorial Requests
  • d_gosbell's avatar
    d_gosbell
    7 years ago
    You could just creat your column with the actual color name/value that you want, then use the "Field value" option
     
    StatusColor = SWITCH([Status],
    "Started", "Blue",
    "Completed","Green",
    "Pending","Yellow"
    )
     
     
     
d_gosbell's avatar
d_gosbell
Super User
7 years ago
cmajewski wrote:

I am running January 2019 and this came out in May 2018 any suggestions as to why I am not seeing the color scales?? I want to color different cells in a column based on the text not a number.

This option is still there, they've just renamed the menu because they added more options than just scales. If you click on the background color option there is a "Format by" setting which now has options for Color Scale, Rule and Field value.

cmajewski's avatar
cmajewski
Frequent Visitor
7 years ago

Many thanks for your reply I see what you are saying. It must be because I am trying to apply the colors to a different visualization than what's in their example that it still looks different when you go into the menu.


What I thought I would be able to do is apply different colors to a column in a table based off the text. For example, I have a ‘Status’ column and I wanted to color the different words so ‘Completed’ would be green, ‘Pending’ would be orange, etc.…


I am accomplishing this now with a nested IF, however I have more than 4 different statuses so it’s not working for all the colors I need:

 

Column = IF([Status]="On Plan",1,IF([Status]="Started",2,IF([Status]="Completed",3,IF([Status]="Pending",4,0))))

 

Any suggestions?

  • d_gosbell's avatar
    d_gosbell
    Super User
    7 years ago
    You could just creat your column with the actual color name/value that you want, then use the "Field value" option
     
    StatusColor = SWITCH([Status],
    "Started", "Blue",
    "Completed","Green",
    "Pending","Yellow"
    )
     
     
     
    • cmajewski's avatar
      cmajewski
      Frequent Visitor
      7 years ago

      Many Thanks!!

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Community Support
        7 years ago

        cmajewski ,

         

        By the way, you may help accept solution. Your contribution is highly appreciated.