Forum Discussion
prabhatnath
3 years agoAdvocate III
Dynamic X Axis based on Slicer using Dynamic table or RANKX
Hi Friends, I have a dataset (Link to the dataset as Google sheet) that has Sprint Name, Start Date, and End Date. The Sprint Name is used as Slicer and Hours Worked (Estimate and Completed columns...
prabhatnath
2 years agoAdvocate III
Hi, johnt75 or any other experts here. Please guide me in this.
Thanks,
Prabhat
prabhatnath
2 years agoAdvocate III
Hi Friends,
I have uploaded an updated PBI file here and looking for any help.
You may go ahead and discard all logic and suggest any new way to get that.
Basically, I have data that has Sprints column that is used in a slicer (single select only) and many visuals in the report are based on the Sprint that is selected.
But I have a requirement where the Column Chart should show data for the selected Sprint and the Previous 2 Sprints. The previous 2 sprints can be determined based on the Start Data and End Date.
Please suggest.
Thanks,
Prabhat Nath