Conditional Formatting based on text fields_Help

[Ak_Pikachu]

Hi All,

I have two text columns from two tables suppose A and B.
I want to display a text column from table A in a matrix visual, 

My question is if table A have values different from table B show those difference in Red Color, conditional formatting

Please help me
Example: 
Table A

1	A
2	B
3	c
4	D
5	E

Table B:

1	A
2	B
3	C
4	D

Final O/P:

1	A
2	B
3	C
4	D
5	E

@parry2k , @amitchandak  

[parry2k · Accepted solution]

@Ak_Pikachu if ID in TableA and TableB is unique and has a relationship, add following DAX measure for color and use it in the conditional formatting:

Color = 
VAR __tableAValue = SELECTEDVALUE ( TableA[Value] )
VAR __tableBValue = SELECTEDVALUE ( TableB[Value] )
RETURN
IF ( __tableAValue <> __tableBValue, "Red" )

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[parry2k · Accepted solution]

@Ak_Pikachu add a new measure something like this and use this in the card visual:

Diff = 
VAR __diff = 
SUMX ( 
    TableA,  
    VAR __tableAValue = SELECTEDVALUE ( TableA[Value] )
    VAR __tableBValue = SELECTEDVALUE ( TableB[Value] )
    RETURN IF ( __tableAValue <> __tableBValue, 1, 0 )
)
RETURN 
IF ( __diff = 0,  "Everything Ok", "Correct the values" )

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Ak_Pikachu]

Hi @parry2k ,

It is showing the same result in both conditions in a card visual, Working fine in a Table visual along with Names.

Please help if there is a way to achieve this

[Ak_Pikachu]

Thank yo so much, It worked

[Ak_Pikachu]

I have another question, I want to display a text box visual, on condition basis

If none of values in Red: "Everything Ok"
If some values in Red: "Correct the Values"

I tried writing the text in the same dax you sent, Its working in a table visual alng with the Column

But I need a text box visual conditionally

Please Help

[parry2k]

@Ak_Pikachu Ok what is the relationship type between these tables? one to one, one to many, if it is one to many which table is on the many sides? it is not about id columns, it is more about if these tables have relationships.

[parry2k · Accepted solution]

@Ak_Pikachu if ID in TableA and TableB is unique and has a relationship, add following DAX measure for color and use it in the conditional formatting:

Color = 
VAR __tableAValue = SELECTEDVALUE ( TableA[Value] )
VAR __tableBValue = SELECTEDVALUE ( TableB[Value] )
RETURN
IF ( __tableAValue <> __tableBValue, "Red" )

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

[Ak_Pikachu]

Hi @parry2k ,

I have another question, I want to display a text box visual, on condition basis

If none of values in Red: "Everything Ok"
If some values in Red: "Correct the Values"

I tried writing the text in the same dax you sent, Its working in a table visual alng with the Column

But I need a text box visual conditionally

Please Help

[Ak_Pikachu]

Sorry for the wrong info, I have no ID column which has relation blw two tables,

There a relation but that is also a Text field

[parry2k]

@Ak_Pikachu the first column (ID) is unique in both the tables?