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

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