Forum Discussion

Rinosh's avatar
Rinosh
Frequent Visitor
3 years ago
Solved

Highlight duplicate values of table column based on selection data

Hi, Need help to highlight the duplicate values of column ( Part number)  based on selection critera.( Cost center)   Eg :- Under lined part number (4002690132) to get hilighted in this selection ...
Need Help
  • Rinosh's avatar
    Rinosh
    3 years ago

    Hi,

    Solved the problem by creating a calculated column for couting duplicate values

     

    Duplicate values = COUNTROWS(FILTER('Table',EARLIER('Part No') =('Table'[Part No]) && EARLIER('Table'[Costcenter])='Table'[Costcenter]))
     
    Futher applied conditional formating based on duplicate values.
     
    Conditional formating --> Icons
     
    Rules --> Value only
     Summarization  --> Sum of duplicate values
    Rule -->
    If Value > 1 Number & Less <= Max Number  , then select color.
     
     
     
     

     

     

     

     

Rinosh's avatar
Rinosh
Frequent Visitor
3 years ago

Hi,

Solved the problem by creating a calculated column for couting duplicate values

 

Duplicate values = COUNTROWS(FILTER('Table',EARLIER('Part No') =('Table'[Part No]) && EARLIER('Table'[Costcenter])='Table'[Costcenter]))
 
Futher applied conditional formating based on duplicate values.
 
Conditional formating --> Icons
 
Rules --> Value only
 Summarization  --> Sum of duplicate values
Rule -->
If Value > 1 Number & Less <= Max Number  , then select color.