Forum Discussion
Display a clusterd column chart based on filtered value
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
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.
4 Replies
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
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)
I can rexplain my problem by :
How to List All child Listed Under a parent by Filtering a child .
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.
