Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • rocky09's avatar
    rocky09
    7 years ago

    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.

     

rocky09's avatar
rocky09
Solution Sage
7 years ago

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.