Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Highlighting duplicated values in table visual in Power BI

Hi everyone,   I'm having problem with using the conditional formatting to highlight the duplicated values in my table visual. My data looks like this To create the conditional formatting, ...
Need Help
Show and Tell
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

     

    Rowcount : =
    IF (
    COUNTROWS (
    CALCULATETABLE (
    'Table',
    ALLSELECTED ( 'Table' ),
    VALUES ( 'Table'[Customer] )
    )
    ) = 1,
    0,
    1
    )
     
     
     
     
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

 

Rowcount : =
IF (
COUNTROWS (
CALCULATETABLE (
'Table',
ALLSELECTED ( 'Table' ),
VALUES ( 'Table'[Customer] )
)
) = 1,
0,
1
)
 
 
 
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I would like to thank you a lot for your answer.

    By the way, is it possible to make it highlight the duplicates of different customers with different colors? For example, the duplicates of A will be blue, and the duplicates of B will be pink.

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Icon for Super User rankSuper User
      5 years ago

       

      Rowcount ColorCondition : =
      IF (
      COUNTROWS (
      CALCULATETABLE (
      'Table',
      ALLSELECTED ( 'Table' ),
      VALUES ( 'Table'[Customer] )
      )
      ) > 1,
      SELECTEDVALUE(Customers[Color])
      )
       
       
       
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Jihwan_Kim 
        Do we have a method that we don't have to create another column to assign color for each customer? Can we just use some randomized colors that are different?   

  • AlessiaZak's avatar
    AlessiaZak
    Regular Visitor
    2 years ago

    Hi, is there a way to filter out empty rows?