Hi,
I'm working with a client to create a dashboard. They want a timeline progress bar with milestones and the ability to drill down and see what task are not complete causing the milestone not to go to 100%. I tried to go the simple route with slicers but the wont a progress bar with milestone that are clickable. Attached is the spreadsheet data is under the data tab. Any ideas or suggestions would be greatly appreciated.
example:
model
progress bar
296 ------------------------------------------------------
milestone1 milestone2 milestone3
click on milestones and task belonging to milestone appear.
------------------------------------------------------
progress bar
249 ------------------------------------------------------
milestone1 milestone2 mileston3
click on milestones and task belonging to mileston appear.
------------------------------------------------------
Bookmarks