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, I followed this forum Solved: how to highlight the duplicate cells in Power BI t... - Microsoft Power BI Community

This is my measure and the conditional formatting.

 

And I created the visual like this

However, when I changed the value of the date slicer from 1/1/2021 to 1/2/2021, the C is still highlighted.

This is the issue that I would like to solve, thank you in advance for your help.

 

Need Help
Show and Tell

7 Replies

  • 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])
        )
         
         
         
    • AlessiaZak's avatar
      AlessiaZak
      Regular Visitor
      2 years ago

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

  • Sgriffiths2000's avatar
    Sgriffiths2000
    Regular Visitor
    4 years ago

    Hello, the conditional formatting works well, thanks!


    But is it also possible to create a new column and assign a marker when a value multiple is found in a specific column?

     

    Small capture below, I'd like to create a new column and add "double" when a multiple is found.