Forum Discussion
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...
- 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")
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" option
StatusColor = SWITCH([Status],
"Started", "Blue",
"Started", "Blue",
"Completed","Green",
"Pending","Yellow"
)
Many Thanks!!
