Forum Discussion
Omar_Sek
4 years agoFrequent Visitor
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...
- 4 years ago
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
4 years agoSuper User
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
4 years agoFrequent Visitor
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_Sek4 years agoFrequent Visitor
I can rexplain my problem by :
How to List All child Listed Under a parent by Filtering a child .