Table to show parent child relationship

[vbourbeau]

Hi,

What I want is when I click on child row only the parent with the same job number appear.

Also if no child selected nothing appear in the parent table.

Thank you

Here link to not working example

https://we.tl/t-m4v5AdWIgp

[parry2k]

@vbourbeau you can achieve this by changing filter direction to both and this link can help you how to show parent on selection of child record.

[vbourbeau]

Thank you for the direction to both but fo hide the selection it's not working well.

In fact the table was hide but the card are above the table so I can't click on the table value.

https://we.tl/t-MCFMHKa8sU

Do you have another solution? 

[Anonymous · Accepted solution]

Hi @vbourbeau ,

When you mean "nothing appear in the parent table" ,are you meaning totally nothing on the page or not to show any data about Parent table?

If it's the latter, you can create a measure as:

Measure = IF(ISFILTERED(Child),1,BLANK())

Then add this measure to filters on Parent visual.

Result would be shown as below:

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[vbourbeau]

Thank you it's work

even if it's work I have a error message in the measure what that mean: "parameter is not the correct type"