cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)