Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

interation between 2 visual to filter data

Hi Guys, I got 2 table visual from 2 different tables. I'm trying to filter 1st visual(master) (on click) to filter 2nd visual(child). And i want to click on 2nd visual returned rows without impacti...
Need Help
Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi Anonymous Could you try with MAX function and check i am attaching a sample

Control_child_table = 
VAR _id = SELECTEDVALUE('contact_master'[id]) 
RETURN
IF(
    NOT(ISBLANK(_id)) && MAX('contact_child'[id]) = _id,
    1,
    0
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Akash, i tried this dax in measure and applied filter on 2nd visual but as soon as i click on child visual data it goes blank. Thanks for you suggestion.

    • Akash_Varuna's avatar
      Akash_Varuna
      Super User
      1 year ago

      Hi Anonymous Is the interactions enabled ? Like bewteen Parent and Child enabled and Child to Parent Disabled like kept to None ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Yes. Parent to child visual is enabled and from child to Parent is kept None. I'm thinking it might be bug in PowerBI. Could you please able to create dummy data and see if it behave properly on your machine. It might be issue with my version of PowerBI.