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

Anonymous Sure I will get back to you

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Thanks Akash

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Akash, i created a dummy file but not sure how to attach here. 

    These are the screenshots of my issue. Thanks

    when i click id=2 then data is filtering fine

    when i click inside data in Child visual it goes blank

     

    • Akash_Varuna's avatar
      Akash_Varuna
      Super User
      1 year ago

      Hi Anonymous Could you try adding a selection for child also 

      Control_child_table =
VAR parent_id = SELECTEDVALUE(Parent[id]) -- Parent Table
VAR child_id = SELECTEDVALUE(Child[id]) --  Child Table
RETURN
IF(
    NOT(ISBLANK(parent_id)) && (child_id = parent_id || ISBLANK(child_id)), 
    1, 
    0
)
      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        I tried still when i click on Child visual data it goes blank. i also added screenshot of changed measure and show Interaction of child with parent visual. on child i applied that dax measure.