How to highlight duplicate values in a table that is filtered by slicers?

[Anonymous]

Hi All, new to Power BI and have a problem that seems rather easy to solve, but I just am not able to work around it, will appreciate any form of help!

I would like to highlight the cells of a table created from a slicer that has appeared more than once from my slicer selection. My idea is to create a measure that counts the appearance of each item in the table. This measure then will be inserted to control the background of the cell colour (ie when the value of the measure is >1)

The list  is created from the slicer above and they read from the same table. I am confused as to how i can write the measure as the table i would like to highlight from is a filtered selection.

Thanks for any help at all! been trying at it for a few days now..

Regards

Felibhai

[VahidDM]

Hi @Anonymous 

Add a measure with this code:

Count By Service Code = DISTINCTCOUNT(Table[Terminal Code])

Then, use this measure to add conditional formatting for Terminal Code in that table chart. IF [Count By Service Code] measure is more than 1, then highlight that cell.

How to add conditional formatting: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

👉If you need more details, please share a sample of your data here in a table format to copy that.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos✌️!!