Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I need help for a scenario, which Im struggling with right now...
Below is the data , which has a Parent Id ,Customer Id and Name. Customer Id is Unique and Names without a Parent Id is the Parent and its corresponding ID under Parent Id column is the Child.
Im trying to create a parameter for Parent ID Like 'Select Parent' It should have only Parent Name like as in the below example its A,B,C. Selecting any Parent it should list the Customers of the Parent.
Any help regarding this scenario would be greatly appreciated. Thanks!
Customer Id | Parent Id | Name |
13 | 1 | AA |
14 | 1 | BB |
15 | 1 | CC |
1 | A | |
16 | 2 | DD |
17 | 2 | EE |
2 | B | |
3 | C |
Solved! Go to Solution.
Hi @DivyaJohn ,
According to your description, here's my solution.
Create a Parent table.
Parent =
SELECTCOLUMNS (
FILTER ( 'Table', 'Table'[Parent Id] = BLANK () ),
"Parent Id", 'Table'[Customer Id],
"Name", 'Table'[Name]
)
Relate the Customer Id in fact table with Parent Id in Parent table.
Put Parent Id in Parent table in slicer, get the result:
I'm not sure if this is the result you want, if not, please explain more about the expected result.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Community Support Team_yanjiang
Hi @DivyaJohn ,
According to your description, here's my solution.
Create a Parent table.
Parent =
SELECTCOLUMNS (
FILTER ( 'Table', 'Table'[Parent Id] = BLANK () ),
"Parent Id", 'Table'[Customer Id],
"Name", 'Table'[Name]
)
Relate the Customer Id in fact table with Parent Id in Parent table.
Put Parent Id in Parent table in slicer, get the result:
I'm not sure if this is the result you want, if not, please explain more about the expected result.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Community Support Team_yanjiang
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
20 | |
13 | |
13 |