Want to have the Column Chart X-Axis Based based on Slicer Selection Plus Calculated Value

[prabhatnath]

I have a Dataset from Azure DevOps with the Sprint Data having Sprint Name, Sprint Start Date, Sprint End Date, and Work Items under the Sprint with Estimated Hours, Completed, etc. The Sprint Names are provided as a Single Select Slicer and the Report shows several details of the Selected Sprint.

The Report also has a Clustered Column Chart that shows information (Estimated vs Completed) from the Selected Sprint.  Is that possible to show the same info (Estimated vs Completed) for the Previous 2 Sprints as well ALONG with the Selected Sprint.

Example:

If I selected Sprint 2406 then ONLY the Clustered Column Chart visual should show details from  Sprint 2406, 2405, 2404. However other visuals in the report page should only show data based on the Selected Sprint (2406).

Maybe we can have a dynamic table that will updated based on the Slicer selection with the previous sprint names based on the Sprint StartDate and EndDate calculated based on the StartDate of the Selected Sprint. And only the Clustered Chart X Axis will be linked to the Dynamic Table? Or some sort of calculation that I am not able to think of.

Here is the PBI File that has loaded sample data from Excel (with refresh disabled) for your information exploration and suggestion. Please help with this.

Thanks,

Prabhat

[Rupak_bi]

Hi,

Dose this meets your requirements?

[prabhatnath]

Yes, the screenshot looks good as per my expectation. Just that instead of the current sprint, the previous and previous 2 we can have the actual Sprint Names. The reason is if we need we can go backward to 2 more sprints or 5 more sprints as per the need.

Can you help me with the code/PBIX so I can understand how to do that?

Thanks,

Prabhat