• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to keep lines consistent when changing tasks in slicer?

ruraljuror

New Member
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:

ruraljuror_0-1743593041492.png



Next, I select a Task Name:

ruraljuror_1-1743593139404.png




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

See link to files below:

PBI File
Dataset
 
Back
Top