Highlighting different rows based on same values from a column

Anonymous — Wed, 28 Dec 2022 12:09:43 GMT

Hi folks,

There is a scenario where I want to hightlight values from Column1 and Column2 based on similar values from Column3.

For better explanation,I am showing an example. This is the table which has 3 Columns. Based on similar values in column3( C ),

lets says b1 , I want to highlight rows in column1( A ) and column2( B ) which are different. So the cells which will be highlighted will be cell B3 and B4 where as A3 and A4 wont be highlighted because they have similar values.

If cells in Column3( C ) has no duplicate value in the column the extire row will be highlighted. eg : c1 value in column 3.

So after all the calculation the table should look like this.

Any help with this will be greatly appreciated.Thanks in advance!

@Greg_Deckler @amitchandak

Re: Highlighting different rows based on same values from a column

Anonymous — Thu, 29 Dec 2022 06:51:06 GMT

Hi @Anonymous ,

I'm not clear about your requirement. When need to highlight the values? If column A or column B has the similar value with the one in Column C, it will highlight the values in column A and column B? You can refer the following links to make conditional formatting on the visual:

Apply conditional formatting in tables and matrixes

highlight row if cell value doesn't match with another row Power BI

Power BI Conditional Formatting

Best Regards

topic Re: Highlighting different rows based on same values from a column in Developer

Highlighting different rows based on same values from a column

Re: Highlighting different rows based on same values from a column