cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mboyd96 Frequent Visitor
Frequent Visitor

Cross Filtering a table with Gantt chart

I'm pulling in data from Azure DevOps and displaying it in a Gantt 2.0.2 chart. I seem to have the parent-child heirarchy set up correctly - Epics are parents, features, stories, tasks, etc are the children. This is set up using a join on the "Parent Work Item" field from an analytics view in Azure Devops, to get all work items to roll up to an epic. I also have a table below the chart, to show all work items and more details than just the gantt chart. 

 

1.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I'd like to click on a segment in the Gantt chart, and have the table cross-filter to all work items belonging to that epic, in the collapsed/rolled up view. Seems like that should be the behavior. However, it is only showing 1 work item when I select a segment in the chart, not all of them. I made sure that all table values are set to "dont summarize". Is there a way to accomplish this?

2.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Cross Filtering a table with Gantt chart

Hi @mboyd96 

As tested, it is the same as yours on my side.

I'm afraid it is by default.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Cross Filtering a table with Gantt chart

Hi @mboyd96 

As tested, it is the same as yours on my side.

I'm afraid it is by default.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

mboyd96 Frequent Visitor
Frequent Visitor

Re: Cross Filtering a table with Gantt chart

So there's no way to work around this? My solution currently is to just use the heirarchy slicer, but being able to click on the Gantt would be nice as well. Thanks for your reply.

Lucian Regular Visitor
Regular Visitor

Re: Cross Filtering a table with Gantt chart

Hello,

I understand "it is by default" (at leas for now)... but I have the same problem and I need a way to overcome this - is there a workaround or an ideea to vote so maybe would be implemented?... because it seems that it should not be "the default" or "by design"... because this is the way the user is used to work with in Power BI - just click on the visual element... and the "related" visual will get filtered... 😉

 

Kind Regards,

Lucian

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,993)