Forum Discussion
Color cell in table view
Hi I have created one Power BI report and I am showing up one table view in my report. There is one column in my table which is holding values as "R", "G" and "Y" and I want to show "R" cell wit...
Make sure you have latest Power BI Installed.
1. Create a Custom Column and assign the Color Codes by using Switch function. Example:
ColorCodes = SWITCH(TRUE(), Table1[Color Symbol] = "B", "#0000FF", Table1[Color Symbol] = "R", "#FF0000", Table1[Color Symbol] = "G", "#008000", Table1[Color Symbol] = "Y", "#FFFF00")2. Go to formatting Tab, select Conditional Formatting and then Select Background and then Select Field Value and then Select ColorCodes Column from the list. I.e.
Step 1 Create custom column assign value(numeric 1=red, 2=green, 3=yellow to them using conditional column (for e.g. new column name "index")
Step 2 once created select column which you want to format
Step 3 go to conditional formating >> backgroung formating >> formating applies to (select column)
Step 4 colors by rule
1 is red
2 is green
3 is yellow