Forum Discussion
Dynamic X Axis based on Slicer using Dynamic table or RANKX
You have the relationship on the wrong columns. You need it from Sprint Index to Sprint number.
Hi John,
Thank you for the hint on the relation column it worked as expected for the Chart, where the chart shows the previous 2 sprint data based on the relation, but Unfortunately, I realized that other parts of the report do not work as expected.
Reason:
Rest all visuals in the report depending on the main table or the selected Sprint Name, but as the main table gets filtered with "current sprint plus previous 2 sprints" all other visuals are impacted.
Ideally the "Column Chart" should be shown based on the "Selected Sprint and the previous 2 sprints" but rest of all visuals should depend on the "main table or only with the Selected Sprint".
Please suggest.
Thanks,
Prabhat
Hi, johnt75 or any other experts here. Please guide me in this.
Thanks,Prabhat
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