Forum Discussion

prabhatnath's avatar
prabhatnath
Advocate III
3 years ago
Solved

Formatting Table Visual Cell Background Color based on Other Column Values

Hi Friends,

I am new to PBI and working on some reports where I have below table data loaded into PBI that I am showing in a Table visual. 

IDTypeSP
1002User Story3
1003Task 
1004Task 
1005Task 
1006User Story2
1007Task 
1008Task 
1009Bug1
1010User Story 
1011Task 
1012User Story1
1013User Story 
1014User Story2
1015Task 
1016Bug 

I want the SP column in the table visual to have specific background color as per the below conditions:

If the Type = User Story OR BUG and SP is NOT Blank (having any positive value) then the SP cell background color should be GREEN
If the Type = User Story OR BUG and SP IS Blank then the SP cell background color should be RED
if the Type <> User Story OR BUG then the SP cell background color should be a GRAY color.

Expected visual:

Please suggest.
Thanks,
Prabhat

Need Help
  • ddpl's avatar
    ddpl
    3 years ago

    prabhatnath Creeate measure as per below:

     

    Measure 2 = var _type = MIN('Table (2)'[Type])
                var _sp   = MIN('Table (2)'[SP])
                return
                    IF((_type = "User Story" || _type = "Bug") && _sp >0 , 1,
                    IF((_type = "User Story" || _type = "Bug") && _sp = BLANK() , 2,
                    IF((_type <> "User Story" || _type <> "Bug") ,3,0)))
     
     Then assign conditional formating as per below:
     

    Please accept as solution if its worked.

1 Reply

  • ddpl's avatar
    ddpl
    Solution Sage
    3 years ago

    prabhatnath Creeate measure as per below:

     

    Measure 2 = var _type = MIN('Table (2)'[Type])
                var _sp   = MIN('Table (2)'[SP])
                return
                    IF((_type = "User Story" || _type = "Bug") && _sp >0 , 1,
                    IF((_type = "User Story" || _type = "Bug") && _sp = BLANK() , 2,
                    IF((_type <> "User Story" || _type <> "Bug") ,3,0)))
     
     Then assign conditional formating as per below:
     

    Please accept as solution if its worked.