Forum Discussion
Gantt chart reference table
- 2 years ago
Hi Anonymous
Check the drill-through functionality:
https://www.youtube.com/watch?v=BbplhqDCWOM&t=1sIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi, Anonymous
Given the scenario you've described, it seems you're already leveraging tooltips to show predecessor information when a Gantt bar is selected. To extend this functionality to a table that dynamically updates based on the selected Gantt bar, you might need to utilize Power BI's ability to create relationships and use DAX to filter and display the relevant predecessor data.
Here is a possible solution:
1.Ensure Data Model Relationships.
2.Use DAX to Create a Measure: You will need to create a DAX measure that filters the predecessor information based on the selected task in the Gantt chart. This measure can then be used in your table visual to display only the relevant predecessors. A basic example of such a measure could be:
SelectedPredecessor = CALCULATE(
MAX('Table'[PredecessorColumn]),
FILTER(
'Table',
'Table'[TaskIDColumn] = SELECTEDVALUE('Gantt'[TaskIDColumn])
)
)
Return the selected value in the table Visual through SELECTEDVALUE. If you want to know more about the use of DAX, you can click the link below:
https://dax.guide/selectedvalue/
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous2 years agoNot applicable
This will help, however, it does not help me handle where in the Gantt there are multiple predecessors listed for a task.