Forum Discussion
Organize sprints chronologically
Hello everybody!
I have three tables:
'dim Calendar' (with dates)
Date
'dim Iterations' (with sprints = 14days periods of time)
iterationid
StartDate
EndDate
SprintName
'fact Work Items' (with work items)
WorkitemID
ClosedDate
1. I need a measure to calculate number of workitems closed per Month, week and per sprint
2. I need to show this in a bar chart, over time and over sprints, where they are sorted in a chronological order.
This is what i am looking to achieve:
1 Should be simple. I'm doing this and it works
CALCULATE(COUNT('fact Work Items'[ClosedDate]),'fact Work Items'[ClosedDate]<>BLANK(),'fact Work Items'[State]="Closed")
2 I struggle with this simmingly easy part. How do I build relation between the three tables to make this work? and what do I need to do for the sprints to be displaying in a chronological order and not alphabetical order?
I'm getting this instead (which isn't right)
2 Replies
V-lianl-msftCommunity Support
Hi Anonymous ,
Is the axis in the chart in text format?
Could you share a pbix file after deleting sensitive data? So I can know your scenario better to check the issue.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- lbendlin
Super User
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.
