Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Anonymous
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.