Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
I have table with Pipelines and Activities. However, In Pipelines Table, I have ParentPipeline and When I select ParentName, data should filter only to specific parent and don't filter childs. Also, When I filter specifc Child, it should filter data for specific child and shouldn't filter parent. Can you please help how to achieve it? Should I need to redesign Pipelines Table?
Pipelines:
Activities:
Pipelines ( PipelineID) 1 --> Activites (*)(PipelineId) ( 1 to Many)
Issue:
When I select ParentName as "Process" Or ParentPipelineID as "B", It should display rows for PipelineID == B but below screenshot display data for child i.e C & D. Please suggest how to display data for ParentPipelineID only i.e PipelineID == B
Thanks,
Abhiram
Hi, You are getting the right result based on the relationship you have created. Just look at your pipeline table, Pipeline ID "C "& "D"only mapped against parent ID B and so the same you are getting. To get Child data for "B" make slicer on pipe line ID column from pipeline table.
User | Count |
---|---|
22 | |
19 | |
12 | |
10 | |
10 |
User | Count |
---|---|
31 | |
25 | |
15 | |
13 | |
12 |