Forum Discussion
How to display when projects drop
To create a dashboard that displays the number of active projects for each project manager by month, you can use a line graph visual in Power BI.
Here's one way to set it up:
1. Create a new line graph visual in your dashboard.
2. Drag the "Project Manager" field to the "Axis" field well of the line graph visual.
3. Drag the "Forecasted Closing Date" field to the "Values" field well of the line graph visual.
4. Create a new calculated column with a formula that will count the number of active projects for each project manager by month. You can use the COUNTIFS() function to do this.
5. Drag the new calculated column to the "Values" field well of the line graph visual.
6 Format the line graph to show the number of active projects on the Y-axis and the months on the X-axis.
Thank you Sahir. I will attempt this weekend and let you know how it goes. I appreciate the guidance. I am self-taught with Powerbi, so I am slow at this.