The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I wanted to change the field value font in table 1 to a specific color if the same value is also in table 2.
Example:
Table 1: 123456, 123789, 456789
Table 2: 456789
Thank you in advance for any insight.
Solved! Go to Solution.
Create Calcualte Column in Table 1 that checks if each value exists in Table 2.
ExistsInTable2 =
IF(
Table1[Value] IN VALUES(Table2[Value]),
"Yes",
"No"
)
Next set conditional formatting rules:
It worked. Thank you so much.
Create Calcualte Column in Table 1 that checks if each value exists in Table 2.
ExistsInTable2 =
IF(
Table1[Value] IN VALUES(Table2[Value]),
"Yes",
"No"
)
Next set conditional formatting rules:
User | Count |
---|---|
146 | |
121 | |
113 | |
67 | |
54 |
User | Count |
---|---|
232 | |
115 | |
102 | |
98 | |
93 |