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.

 

  • OU812's avatar
    OU812
    Advocate I
    3 years ago

    rocky09 thank you for your answer. I believe that is exactly what I need as well. However, I am so new to PowerBI, I don't even know where to put that DAX code. Can you provide some more detailed steps to implement your answer. I believe I can figure out how to add the column in the table. But some more on that might be helpful as well. Piecing all this together off YouTube videos and forum posts has been rough. Thank you!