Flag values that are not allowed

[LSLjsb1982]

Is there a way to highlight the PN Removed and PN Installed red if it doesn't fall within the correct PN based on the Pack Style? An A319 can only have ACM 1814A0000-XX and PL 1816B0000-XX installed on that config. If the wrong PN is installed can I highlight that number through a function? Top left would be the correct ACM and PL based on AC and Pack, bottom is my table of removals and installs some being incorrect. I need to flag the incorrect ones with a color or icon.

[v-ssriganesh]

Hello @LSLjsb1982,
Thank you for reaching out to the Microsoft Fabric Forum Community.

I have reproduced your issue in Power BI Desktop based on your requirement where specific PN Removed and PN Installed values should be highlighted in red if they do not match the allowed part numbers based on Aircraft Type and Pack Style.

I implemented this using rule-based conditional formatting with a helper flag column (1 = valid (True), 0 = invalid (False)) and applied it to both columns successfully.

Achieved the expected output where incorrect values are flagged in red(false) matching your original requirement:

For your reference and testing, I’ve attached a .pbix file that you can explore and customize as needed.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[speedramps]

Try this ...

dont have have any relationship between your repairs table and config table

This measure will return TRUE is the part is valid or FALSE if it is invalid.

You can use it in conditional formating to change the colour

SELECTEDVALUE will get the cursor cell value 

which I call my part and my config

FILTER then creaste a temp table of any rows on the config table that match

ISEMPTY checks if the temp table is empty

Is installed part valid =
VAR mypart = SELECTEDVALUE(repairs[PN install])
VAR myconfig = SELECTEDVALUE(repairs[Aircraft family]
VAR matchingcongfigs =
FILTER(config, 
config[acttype) = myconfig  &&
config[PLinstalled)= mypart)
RETURN
ISEMPTY(matchingcongfig)

Please click thumbs up and accept solution