Forum Discussion
Conditional formatting not working when column is added to table visual from connected table
I got one table which contains 3 columns:
| Name | Ref | ID |
| item 1 | 0 | 1001 |
| item 2 | 1 | 1002 |
it is connected by ID to second table containing values.
If I want to conditionally format Name column to set backround color based on Ref column (for example if column equals 0 set bg color to red)
This works perfectly fine. But as soon as I include a Value column from connected table the conditional formatting dissapears. Why is this happening?
Hi msaj43
Based on your needs, I have created the following table.
Rrlationship between two tables:Then you can create the following measure to conditionally format Name column:
Measure = IF(SELECTEDVALUE('Table (2)'[Ref]) = 0,"red","green")
Result:Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hello msaj43 ,
Please check the below..
1. If the relationaships beteween two tables from where value is coming is connected and active.
2. Use Field Value Conditional Formatting using DAX instaed of Direct formatting.
3. Also check the data type if the new columns one is same as old one.
If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!
Thank You
Dharmendar S
Hi msaj43
Based on your needs, I have created the following table.
Rrlationship between two tables:Then you can create the following measure to conditionally format Name column:
Measure = IF(SELECTEDVALUE('Table (2)'[Ref]) = 0,"red","green")
Result:Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
