How to keep lines consistent when changing tasks in slicer?

[ruraljuror]

I'm working on a report to calculate resource capacity, and I was asked if it's possible to "freeze" the lines when a task name is selected, once the team name is selected. The goal is to visualize stacked bars that update based on task name selection, showing the total FTE by status and comparing it with the frozen lines.

I tried editing the interactions, but it didn't seem to have any effect. Is this achievable? If not, I'm open to suggestions or alternative approaches.

Here the Team Name only is selected:

Next, I select a Task Name:

So, ideally, I would like to see the lines in the first image remain the same in the second image.

[ruraljuror]

Amazing. Thank you!

[danextian]

Hi  @ruraljuror 

When task name is selected and the filter is coming from the same or related table, it also affects the visible dates so in order for the lines to freeze, all the dates for those lines must remain visible.  This could be possible with a slicer from a disconnected table. But I don't have a sample data to test...

If you want to proceed, please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.

[ruraljuror]

Hi @danextian , thanks for your reply. I have saved the files in a Google Drive folder.

PBI file 

Dataset 

[danextian · Accepted solution]

Hi @ruraljuror 

Please see the attached pbix