Forum Discussion

karo's avatar
karo
Icon for Advocate V rankAdvocate V
7 years ago
Solved

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

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

Need Help
Tips and Tricks

4 Replies

  • CSteff's avatar
    CSteff
    Frequent Visitor
    5 years ago

    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? 

    • MattGell's avatar
      MattGell
      Icon for Advocate I rankAdvocate I
      6 years ago

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