Highlighting duplicated values in table visual in Power BI

[Anonymous]

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.

[Sgriffiths2000]

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.

[Jihwan_Kim · Accepted solution]

Rowcount : =

IF (

COUNTROWS (

CALCULATETABLE (

'Table',

ALLSELECTED ( 'Table' ),

VALUES ( 'Table'[Customer] )

)

) = 1,

0,

1

)

Link to the pbix file 

[AlessiaZak]

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

[Anonymous]

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]

Rowcount ColorCondition : =

IF (

COUNTROWS (

CALCULATETABLE (

'Table',

ALLSELECTED ( 'Table' ),

VALUES ( 'Table'[Customer] )

)

) > 1,

SELECTEDVALUE(Customers[Color])

)

Link to the pbix file 

[Anonymous]

@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]

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.