Background color Set

hello rajasekar_o 

please check if this accomodate your need.

1. create a new measure with following DAX.

Color Palette =
IF(
    SELECTEDVALUE('Table'[Description])="A",
    "Red",
IF(
    SELECTEDVALUE('Table'[Description])="C",
    "Blue"
))

2. select your table visual, then go to Cell Element then which conditional color you want, then go to Format Style, then pick the measure that has been created.

 

Hope this will help.

Thank you.

1) Create a color measure

Example: highlight section headers and totals.

Row Background Color =
VAR Desc = SELECTEDVALUE ( 'Table'[Description] )
RETURN
SWITCH (
    TRUE(),
    Desc = "A.REVENUE",              "#E3F2FD",   -- light blue
    Desc = "Total A.REVENUE",        "#BBDEFB",   -- darker blue
    Desc = "B.EXPENSE",              "#FCE4EC",   -- light pink
    Desc = "Total B.EXPENSE",        "#F8BBD0",   -- darker pink
    BLANK()
)

2) Apply it to the visual

1. Select your Table / Matrix

2. Go to Format pane

3. Values → Conditional formatting → Background color

4. Click fx

5. Set:

   • Format by: Field value

   • Based on field: Row Background Color

   • Summarization: First