How to highlight duplicated values in table/pivot table vizualization?

[karo]

Hi,

I am wonder if there is a possibility to highlight and filter duplicated values/rows in the table/pivot table. It is a basic conditional formating option in excel, but I cannot find a way to do the same in the PowerBI visualization. Any hints?

Regards,

Karo

[CSteff]

WIth all respect, I don't see how this can be flagged as a solution. It is obvious that some sort of measure must be used to help with conditional formatting. But how this measure is to be calculated?

• Find repeat values?
• Count of unique values is greater than 1
• Compare each value with the rest of values

Each of the above may or may not be a workable indicator, but how are they calculated? 

[v-chuncz-msft · Accepted solution]

@karo,

You may add a measure and take advantage of Conditional table formatting in Power BI Desktop.

[MattGell]

come on guys, thats an idea not a solution - where's the example measure in dax to calculate and flag the duplication?