Forum Discussion
Conditional Formatting Duplicate Records in Rows
I've been researching this for hours and I've given up. What I need is simple. I just need to apply conditional formatting to any records that match a record in another row. I'm sure this is simple but I'm new to Power BI so I could use some guidance.
Here's an example of what I want it to look like. This is a table that shows users logged into computers and how many hours they've been logged in. I'd like to highlight the current user if they are logged into more than one system.
Hi,
If i understand it correctly than this should work.
Create a calculated column
CountDistinct = VAR CountDistinct = Table[Current User] RETURN CALCULATE( COUNTROWS('Table'), ALL('Table'), Table[Current User] = CountDistinct )Replace the table and column with your own and in the conditional format on current use make it look like this
9 Replies
Hi,
If i understand it correctly than this should work.
Create a calculated column
CountDistinct = VAR CountDistinct = Table[Current User] RETURN CALCULATE( COUNTROWS('Table'), ALL('Table'), Table[Current User] = CountDistinct )Replace the table and column with your own and in the conditional format on current use make it look like this
Sure, all you would need to do is put the code inside an IF statement such as
CountDistinct = IF(Table1[System] ="Com5",1, VAR CountDistinct = Table1[Current User] RETURN CALCULATE( COUNTROWS('Table1'), ALL('Table1'), Table1[Current User] = CountDistinct ))
Hi, The given solution worked perfectly for me as well. Thanks for that. I am looking for a slight variant, if possible. Is it possible not to highlight only the first record?
Gordonlilj This will not work if there are more than 2 duplicates. How can I achieve this when I have more than 2 duplicates in data?
