Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey everyone,
I got a request to build "a cosmic ship" 🙂
I need to show the amount of task through it's status during the period, but everyday it must include previuos tasks + new task.
What I have is columns Work date (date format), Issue Key ( exp. HND-254, PSD-36 and ect.) and Issue status (Done, Testing, In Progres, New, Backlog).
And I need to show in area chart their change as in Example 1, but when I try to manage it in Power BI it comes like in Expample 2, as I understand that for every day I have to count issue comulative. Have any idea how to do that?
It's a bit difficult to explain, the data is text not a number I'm new at this field, so I'm adding you a part of my report, maybe it will clear the view
https://app.powerbi.com/groups/me/reports/3f7eae71-7a29-46f7-9638-095cfeb17287/ReportSection
@Anonymous
Can you try to create a measure?
IssueKey cnt = COUNTX ( FILTER ( yourTable, yourTable[WorkDate] <= MAX ( yourTable[WorkDate] ) ), IssueKey )
If this is not your case, please post some sample data.
Hey everyone,
I got a request to build "a cosmic ship" 🙂
I need to show the amount of task through it's status during the period, but everyday it must include previuos tasks + new task.
What I have is columns Work date (date format), Issue Key ( exp. HND-254, PSD-36 and ect.) and Issue status (Done, Testing, In Progres, New, Backlog).
And I need to show in area chart their change as in Example 1, but when I try to manage it in Power BI it comes like in Expample 2, as I understand some how I have to calculate day issue = previuos amout + this day tasks.
Could anyone hep me?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |