How to Give A color for specific cell

[rajasekaro]

hi team,

like this i want to give 

[v-hjannapu]

Hi @rajasekaro,

I would also take a moment to thank @danextian  , @JamieHolding, @cengizhanarslan, @rohit1991  for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.

[danextian]

Hi @rajasekaro 

If you're going to use a table visual, @cengizhanarslan 's suggestion would work. However, if this will be in a matrix, conditionally formatting row and column headers is not currently supported - the same color will be applied to the whole headers.

[JamieHolding]

Further to what others have said, if you're working with a matirx, you can go on

Format>Visual>Cell elements>Font Color

This requires a field to be in the Values section of Build, and allows you to format the text based on other fields. 

[cengizhanarslan · Accepted solution]

1) Create a color measure

Create a DAX measure that returns a color code based on the row’s Description.

Example (adjust text values exactly as in your data):

Row Color =
SWITCH (
    TRUE (),
    SELECTEDVALUE ( 'Table'[Description] ) IN {
        "A. INCOME",
        "B. TRADING / MANUFACTURING EXPENSES",
        "C. GROSS PROFIT (A-B)",
        "E. TOTAL (C+D)",
        "G. PROFIT FROM BUSINESS (E-F)",
        "I. PROFIT AFTER INTEREST (G-H)",
        "K. PROFIT BEFORE TAX (I+J)",
        "L. PROFIT AFTER TAX (L-M)"
    }, "#C00000",   -- Red
    "#000000"       -- Black (default)
)

2) Apply it to the visual

For Table or Matrix:

1. Select the visual

2. Go to Format pane → Cell elements (or Conditional formatting)

3. Choose:

   • Font color (or Background color if you prefer)

4. Click fx

5. Set:

   • Format by: Field value

   • Based on field: Row Color

   • Summarization: First

Now only those specific rows will appear in red.

[rohit1991]

Hii @rajasekaro 

In Power BI, you can color a specific cell by using Conditional Formatting based on a rule or a helper measure. In a Table or Matrix visual, go to Format pane >> Conditional formatting >> Background color (or Font color), choose Format by = Rules or Field value, and define a condition (for example, when Description = "GROSS PROFIT" or when a value > 0). If the condition is met, Power BI applies the color only to that cell. Power BI does not allow manual cell-by-cell coloring, so conditional formatting is the correct and supported way to achieve this.