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
    )
     
     
     
     
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?   

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

      Hi,

      Thanks for your feedback.

      In my opinion, if the 'Customers' table in your model has a primary key column ( for example, ID column) that identifies each customer, then I think you can use that column to assign the random-color for each customer. If you do not have an ID column, then you can try to use the customer name to give a unique number to each customer, then you can use that unique number to assign a random-color for each customer.