Forum Discussion
Creating time series visualization from data snapshot
Hi everyone!
I am new to Power BI and still discovering how to make insightful visualizations in it! I am managing a few projects and am struggling to make a time series type bar chart based on data that has static values. This is a very simplified example of the data i am working with (stages are incremental and if there is no entry date for next stage, that means that the project is still in its previous stage - project A continues to be in stage 2 from feb to current month):
| Project name | Stage 1 entry date | Stage 2 entry date | Stage 3 entry date |
| A | 1/1/2021 | 2/1/2021 | |
| B | 2/1/2021 | 3/1/2021 | 5/1/2021 |
| C | 2/1/2021 | 3/1/2021 | 6/1/2021 |
I want to create a bar chart that will show me how many projects are in each stage in each month. Some thing like this:
Can you help me on how I can get this? Thank You!!
13 Replies
Since you want this by month you need a separate (disconnected) table with month names and codes. What should happen at the end of the year, by the way?
Then you create a measure that calculates for each stage how many projects were active in that month.
My idea was that the visualization keeps automatically updating to the current month. Projects get added on, shifted to other stages every so often and the idea is to get a historical progression of projects within stages till today/current month. About your comment on connecting month table to the table I have shown above, I am not sure how to connect the two tables with a common variable. I was thinking that the logic would be "go through each project entry in table 1, if stage x entry date is for e.g. Jan 2020, then no. of projects in Jan 2020 in stage x becomes +1. But I am not sure how to connect the month and project table to do that.
Hi,
What is the maximum number of stages you can have?
There are 6 stages in total and the stages don't change.
