Forum Discussion
interation between 2 visual to filter data
Thanks Akash
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_Varuna1 year agoSuper User
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 ) - Anonymous1 year agoNot applicable
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.
- Akash_Varuna1 year agoSuper User
Could you please provide me the sample data in csv or xlsx
- Anonymous1 year agoNot applicable
It won't let me attach file so i added sample data in below tables. Thanks
Parent Table
ID Name
1 a 2 b 3 c 4 d 5 e Child Table
ID Name
1 ab 1 cd 1 ef 2 gh 2 ij 3 kl 3 mn 4 op 5 qr - Akash_Varuna1 year agoSuper User
Hi Anonymous
Control_child_table = VAR parent_id = MAXX(ALLSELECTED('Parent Table'), 'Parent Table'[ID]) -- Get Parent ID, ignoring Child selection VAR child_id = MAX('Child Table'[ID]) -- Current Child ID RETURN IF( NOT(ISBLANK(parent_id)) && child_id = parent_id, 1, 0 ) - Akash_Varuna1 year agoSuper User
- Anonymous1 year agoNot applicable
Hi Akash, i updated with dax you mentioned above now its showing a value (5, qr) even when no row selected in parent view. I think main concern is when i cick id 1 on parent it filter in 2nd view but as soon as i click inside data in child visual it reset back to(5,qr). we need to preserve selected values based on parent view.