Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

comulative flow chart

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?



Need Help
Show and Tell

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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?

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    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.