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
zubair242
Frequent Visitor

filter child/parent records based on the filter

Hi everyone,

I have a scenario where I want to filter out child/parent record based on the filter applied. Currently, if I created a relationship with child, it filters out only records where it appears as a child. However, I want to filter out those as well records in the table visual where it appears as a parent like below. Any suggestions?

 

zubair242_0-1697435228282.png

 

1 ACCEPTED SOLUTION
zubair242
Frequent Visitor

Hi @Sri_Murugan 

 

Thank you for providing the solution. However, it is a manual solution, so it would not work for my case.

 

Hi @Idrissshatila ,

 

Thanks for your suggestion. I was able to solve the problem following the below article.

 

Creating a slicer that filters multiple columns in Power BI - SQLBI

 

Thanks all.

View solution in original post

5 REPLIES 5
zubair242
Frequent Visitor

Hi @Sri_Murugan 

 

Thank you for providing the solution. However, it is a manual solution, so it would not work for my case.

 

Hi @Idrissshatila ,

 

Thanks for your suggestion. I was able to solve the problem following the below article.

 

Creating a slicer that filters multiple columns in Power BI - SQLBI

 

Thanks all.

Sri_Murugan
New Member

Sri_Murugan_0-1697443683236.png

 

1=> Raw data

2=>Result

3=>Filter applied

 

I have created a calculated column and used in slicer. Hope this approach may helps you..

 

zubair242
Frequent Visitor

Hi @Idrissshatila ,

 

Thanks for your swift response. However, the problem in this solution is that if a person searches client, he/she will have to select all the parents of client manually in the slicer to see those records. Ideally, if he/she selects only 1 record, it should filter where ever it appears in both of the columns. I am not sure how this can be achieved.

Hello @zubair242 ,

 

you could add another slicer for child only that will make it easy to select all clients.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Idrissshatila
Super User
Super User

Hello @zubair242 ,

 

so what you do is that you put both parent and child fields in one slicer above each others, so it will show each parent what you have as a child under it and then you can click for the child of each parent.

 

Idrissshatila_1-1697436459406.png

 

 

Idrissshatila_0-1697436442460.png

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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