Conditional Formatting Quesiton

[cmajewski]

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 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.

Kind regards,

[d_gosbell]

---

@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]

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 · Accepted solution]

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]

Many Thanks!!

[v-chuncz-msft]

@cmajewski ,

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