CODEWITHSUNDEEP
formattingpowerbiconditional-statementsdax
Istiak Mahmood
Istiak Mahmood

Reputation: 2422

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

I have 2 columns in a PowerBI table which I would like to compare and highlight if the value doesn't match.

Example -

ID   Column1   Column2
1      AA        AA 
2      BB        BBA
3      DD        DD
4      EE        E

In the output, I would like to highlight the column 1 cell or the entire row if the value is not an exact match with column 2.

I have search a lot for the solution and strangely I haven't found any solution. Can someone help me to solve the problem!

Upvotes: 0

Views: 2215

Answers (1)

Agustin Palacios
Agustin Palacios

Reputation: 1206

This is my solution: First create an auxiliar column with a simple logic to detect wich rows are different.

NoMatch = IF( Tabl3[Column1] = Tabl3[Column2], 1, 0 )

Then select your visualization and go to Format --> Conditional Format. Select the ID column, activate the background color option and select advanced options. Go to rules and select the column NoMatch then you have to create 2 rules as the followings (My pbi version is on spanish but you will get the idea) enter image description here

Repeat this process for every column you are interested.

This is the result

enter image description here

Hope it helps you.

Upvotes: 2

Related Questions