Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Line chart with item status

Hello all,   I hope you can help me. I would like to have a line chart that shows the status of an item. An item can be open or closed. Open items can be overdue. My fact table looks like the one b...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

Best Regards

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous , thank you very much! It is almost what I would like to achieve, but for now the calculation doesn't work. For example, if you look at the items with a create date of 1-1-2020 (1 January 2020, dd-mm-yyyy):

ItemNo CreateDate DueDate CloseDate
1 1-1-2020 1-4-2020 31-3-2020
2 1-1-2020 1-4-2020 31-3-2020
3 1-1-2020 1-4-2020 1-6-2020
4 1-1-2020 1-4-2020 1-6-2020
5 1-1-2020 1-5-2020 1-6-2020
6 1-1-2020 1-6-2020 31-5-2020
7 1-1-2020 31-12-2020
8 1-1-2020 31-12-2020
9 1-1-2020 31-12-2020

 

On 1-1-2020 there are 9 open items. 2 are closed on 31-3-2020, so on that date there are 7 open items. On 1-4-2020 4 items are overdue, of which 2 are closed. So on 1-4-2020 there are 7 open items, of which 2 are overdue. And on 1-5-2020 there are 7 open items, of which 3 are overdue.

 

Thanks again,

Frank

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

    I updated the sample pbix file(see attachment), please check whether that is what you want.

    Best Regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous , thank you so much. This is exactly what I was looking for!