Forum Discussion
Help with progress of issues visualization
Hi all,
I need help in drawing a line or column chart that shows the amount of items with status=open over time. So for instance, 3 days ago there were 2 open items, two days ago 3, yesterday 1 and today 2. (The excel below is not corresponding to this example, but hopefully you get the idea).
The data is coming from the protected source, but I have illustrated the columns such as:
| ID | Status | Created at | Closed at | Reporter | Department |
| 57938 | Open | 3.1.2021 | null | Jack | Sales |
| 57930 | Closed | 14.4.2021 | 15.4.2021 | Megan | Sales |
| 78983 | Pending | 4.4.2021 | null | Rachel | Marketing |
| 57899 | Open | 16.4.2021 | null | John | Finance |
| 29057 | Closed | 6.12.2020 | 14.4.2021 | Ricky | Sales |
| 28947 | Closed | 16.11.2020 | 13.3.2021 | Tom | Finance |
So the basic idea is to draw a chart, that I can visualize number of open items compared to yesterday and days before yesterday versus today.
Do I have to create a separate date table to be able to track historical data? Can someone help me out with the issue?
If something is unclear and more information needed, don't hesitate to ask.
BR
Jere Aallikko
Hi, jereaallikko
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
All measures are in the sample pbix file.
https://www.dropbox.com/s/tgw3rb1a31vk8v2/jera.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
2 Replies
Hi, jereaallikko
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
All measures are in the sample pbix file.
https://www.dropbox.com/s/tgw3rb1a31vk8v2/jera.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/Hi Jihwan_Kim
That worked out perfectly. Needed to modify the DAX calculations a bit to my specific data but managed to do it.
Thanks a lot!
Br
Jere
