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 criteria ( HMV--FZC08DT)

 

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.
     
     
     
     

     

     

     

     

3 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi  Rinosh ,

    Pls share your pbix file ,remember to remove confidential data.

     

     

    Best Regards

    Lucien

    • Rinosh's avatar
      Rinosh
      Frequent Visitor
      3 years ago

      Hi,

       

      Can you please share your E mail id. i could not upload the PBIX file

  • 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.