cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Creating a milestone slippage chart

Hi I have a data set similar to the below

 

 Months
Milestone01/01/201901/02/201901/03/201901/04/201901/05/201901/06/201901/07/2019
A01/01/201901/01/201901/01/201901/01/201901/01/201901/01/201901/01/2019
B03/02/201915/04/201915/04/201920/04/201920/04/201920/04/201920/04/2019
C15/06/201915/06/201920/06/201901/06/201901/06/201901/06/201901/06/2019
D20/06/201920/06/201925/06/201925/06/201925/06/201925/06/201925/06/2019
E15/07/201915/07/201920/07/201915/07/201915/07/201915/07/201915/07/2019

 

Each month, I get an update for milestones A-E (Months are the row headers)

 

and I want to build a chart like this:

 

Capture.PNG

 

I can't seem to add in a 2nd date for the Y axis, I'm guessing people don't usually do this sort of thing, so probably needs to be in python or R?

4 REPLIES 4
F2003066
New Member

Could you please share how you solved this problem? I seem to need something similar.

dearwatson
Responsive Resident
Responsive Resident

Hi timneo

 

Yep I don't think thats possible with the default visuals and I don't know of a custom visual for a slippage chart yet. 

 

You could be the pioneer! 

 

I'd be looking to R or building something custom to solve this one. 


Cheers

Greg

"The commonality between science and art is in trying to see profoundly - to develop strategies of seeing and showing." - Edward Tufte
Anonymous
Not applicable

Cheers,

 

Just so I understand this, both R and PY require a non default install for use.  So anyone with the desktop client will need R or Python install to view the output.

 

I assume if the server has python installed, anyone can view it on the server, just not desktop?  Our IT is locked down, so I'll have to get them to install R/python before I can make any changes.

Anonymous
Not applicable

nb the blue triangle is a nice to have and isn't in the data set - it covers the data points that have effectively happened to show no further updates will happen for that data set.  its data points would be the same on each axis, ie X:01-Jan-19 Y:01-Jan-19, X:01-Feb-19 Y:01-Feb-19 etc

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors