Forum Discussion
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 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,
- You could just creat your column with the actual color name/value that you want, then use the "Field value" optionStatusColor = SWITCH([Status],
"Started", "Blue","Completed","Green","Pending","Yellow")
5 Replies
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.
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?
- You could just creat your column with the actual color name/value that you want, then use the "Field value" optionStatusColor = SWITCH([Status],
"Started", "Blue","Completed","Green","Pending","Yellow")
