Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Omar_Sek
Frequent Visitor

Display a clusterd column chart based on filtered value

capture 01.JPG

 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.

capture 02.JPG

capture 03.JPG

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

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

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 )

child.gif

 

 

Best Regards,

Icey

 

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

View solution in original post

4 REPLIES 4
Icey
Community Support
Community Support

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 )

child.gif

 

 

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
Super User
Super 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

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 .

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.