Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Change the interaction mode from "cross highlighting" to "cross filtering" and you get your desired behavior without the need for measures.
Thank you for your suggestion, however, it did not solve the problem.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |