Hi,
I have a Gantt chart and would like to show more information when someone clicks on one of the bars in the chart. The bars represent parts of products (ID 4 and 5 in the table).
When a bar (part) is selected I want to show the summary of the issue which is linked to this part. E.g. when someone selects ID 4 (Part 4), the table should show the summary "XYQ" of ID 1 (issue 1).
How can I write a measure which allows a table to display only the issues which are linked to the selected part?
There is a path available which works from higher levels (Product, part, sub part, issue) to lower levels. Furthermore, this path is available in separate columns, so issues have a link to Part ID included. However, Parts do not have a direct link to Issues.
ID | Summary | Type | Parent | Path | Product ID (LVL1) | Part ID (LVL2) | Sub Part ID (LVL3) | Issue ID (LVL4) |
1 | XYQ | Issue | 3 | 3|4|2|1 | 3 | 4 | 2 | 1 |
2 | ABC | Sub-part | 4 | 3|4|2 | 3 | 4 | 2 | |
3 | DEF | Product | 6 | 3 | 3 | - | - | |
4 | GHI | Part | 3 | 3|4 | 3 | 4 | - | |
5 | DJI | Part | 3 | 3|5 | 3 | 5 | - | |
My intuition says the measure should allow to show "all summaries", of “all issues” which have “the Selected Parts’ ID” in their own “Part ID column”.
Thank you so much,
Gijs
