Display a clusterd column chart based on filtered value

[Omar_Sek]

 the first picture is my dataset, in this dataset, I have a parent, child, and value. 

I want to put a slicer that contains child values, and when I select a child I show all his brothers with values associated in a clustered column.

for example: if I filter child 01 I want to display in my clustered chart all his brother (child 01,child02,child03) with values.

 

my solution :

1* I created a measure "parent selected child" and I tried use filter function of clustered column chart to put parent is this measure but it doesn't function.   
2* I created two filters, the first filter I put the child, and the second I put the parent, and I disallowed the interaction between the first filter and the graph but in the graph, it displays just one bar which is the parent with the value of the sum. 
Thankx

 

[Icey · Accepted solution]

Hi @Omar_Sek ,

Try this:

Measure =
VAR SelectedChild =
    SELECTEDVALUE ( 'Child Table'[child] )
VAR SelectedParent =
    CALCULATE ( MAX ( 'Table'[parent] ), 'Table'[child] = SelectedChild )
RETURN
    IF ( MAX ( 'Table'[parent] ) = SelectedParent, 1 )

Best Regards,

Icey

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

[amitchandak]

@Omar_Sek , Not very clear, But use the expand icon on the top of bar visual 4th from left and check. and check if that can help

[Omar_Sek]

I am using this bar visual, but i want to display just the brother of the selected value.

As I explained if I filter child 01 , in my visual I want to see the brother ( child who has the same parent )of child 01 ( child 01,child02, child03)

[Omar_Sek]

I can rexplain my problem by : 

How to List All child Listed Under a parent by Filtering a child .