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