Forum Discussion

ravirayala4252's avatar
ravirayala4252
Helper I
3 years ago
Solved

Highlight the values in Table A from Table B - Conditional formatting !..

Dear experts  I have a Situation here, Please help me with Solution.  I have created 2 table visuals, which are connect through 2 bridge table.  
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi  ravirayala4252 ,

     

     

    Here are the steps you can follow：

    1. Create measure.

    Flag =
var _columnB=MAX('TableB'[Order ID])&""&MAX('TableB'[Material ID])
var _columnA=SELECTCOLUMNS('TableA',"Group",'TableA'[Order ID]&""&'TableA'[Material ID])
return
IF(
    _columnB in _columnA,"red","white")

    2. Select [Actual Hours] – Conditional formatting – Background color.

    3. Result:

     

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

ravirayala4252's avatar
ravirayala4252
Helper I
2 years ago

Hai amitchandak Anonymous 

I think it is better to rephrase my question.
I have 2 tables with are not directly connect, which are connect throught 4 bridge tables. i did this to avoid many to many relation.
I have created 2 table visuals from these 2  tables say A,B.
Table A & B have common columns (Order ID , Material ID & Market ID).
Now i want to highight the matching b/w two table visuals. I used the following measere but it's not wotking for me.please suggest me appropreated on.
FYI, Below measure error i'm getting was not able to see the table B in related function .

1. MatchingHighlight =
IF(
COUNTROWS(
FILTER(
ALL(DateTable, OrderIDTable, MaterialIDTable, MarketIDTable),
COUNTROWS(
FILTER(
Table1,
Table1[Order ID] = RELATED(OrderIDTable[Order ID]) &&
Table1[Material ID] = RELATED(MaterialIDTable[Material ID]) &&
Table1[Market ID] = RELATED(MarketIDTable[Market ID]) &&
Table1[Date] = RELATED(DateTable[Date])
)
) > 0
)
) > 0,
"Match",
"No Match"
)