Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have 3 tables.
Table 1:
Incident Id, Title
Table 2:
Change Id, Title
Table 3:
Change Id, Incident Id, change title, incident title
Relationship between Table 1 and Table 3: 1 to Many
Relationship Between Table 2 and Table 3: Many to Many
As one change can have multiple incidents and one incident may be mapped with multiple changes. Now when I plotted the matrix table and added change id and incident id as rows it is fine. But I need to show their corresponding titles as well.
1. When I am selecting change title in values it is showing the change title in child incidents too
2. when I am expanding the rows and when I am adding incident title in values column it is showing only title for incidents
3. When adding both it is showing in two different columns.
Please help
Hi Souraj,
Please share sample data and expected output to help you with this problem.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
9 | |
7 |