Covered in this video is how to create different filter types, including a slider for showing specific tasks for sprint and project work. We also describe how each dataset can be filter independently for each graph within the dashboard.
- [Voiceover] Now, I have the two graphics…built into a single page.…I'd like to further enhance this…by filtering on each of those graphics.…And as you can see, in each of the graphics now,…I have filtering capability to choose what I want.…So, I'm gonna select the Filter drop-down…for Sprint Number, and as you can see,…I have All selected here.…And if I select the check box,…I can even further define that into a single Sprint.…So, if I wanted to include all of the information…that was part of the Task data,…but not part of the Sprint information,…I could deselect everything and just select Null,…and that would give me the work value…for all of the resources associated with the summaries…for non-Sprint activities.…
I can also expand this by just dragging it up a little bit,…and just, in the Sprint one,…repeat that same filtering option,…again, selecting Multiple here…and expanding that out.…And if I was only interested in a specific Sprint,…I could clear this off and maybe, I'll select 1 and 2,…since those are the Sprints I'm interested in,…
NOTE: This course was designed in collaboration with Bonnie Biafore. The techniques shown work equally well with Microsoft Project 2010, 2013, and 2016.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Using existing report templates
- Creating new visual report templates
- Building a task burnup report with an Excel pivot table and graph
- Building a WBS report with Visio pivot diagrams and filters
- Developing a dashboard report with multiple datasets