cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Sankey chart(?) to show when and in what order?

I have a huge table (several million rows) showing data about when students sat exams. Our exams follow a fairly linear route (people tend to do exam 1, then 2, then 3 etc.)

 

What I want to show is a Sankey-style chart mapping the routes people take through our exams - where they drop out or loop back on themselves (e.g. re-sit an exam etc.)

 

The data I have is something like this:

Candidate IDExamExam dateGrade
00001Basic1st Jan 2006Pass
00002Basic1st Jan 2006Pass
00003Basic1st Jan 2006Fail
00003Basic1st Mar 2006Pass
00001Intermediate1st Mar 2006Pass

 

I'm sure there is lots of really interesting stuff I can do with all this data - but I'm struggling under the sheer weight of the amount of it (big data eh? Smiley Happy)

 

From the above what I'd want is a chart showing 00001 went from Basic to Intermediate; 00002 did Basic and then dropped out; 00003 did Basic, then did Basic again etc.

 

Hope someone out there can help. Thanks in advance.

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Sankey chart(?) to show when and in what order?

Hi @acs,


I'm sure there is lots of really interesting stuff I can do with all this data - but I'm struggling under the sheer weight of the amount of it (big data eh? Smiley Happy

You can use your columns(i.e. Exam or Exam date) as Slicers to pick only some of your data you want to be shown on the report, and change it anytime needed. Smiley Happy


From the above what I'd want is a chart showing 00001 went from Basic to Intermediate; 00002 did Basic and then dropped out; 00003 did Basic, then did Basic again etc.


Though the Sankey chart cannot give you the exactly output you want, it should be a good option here. You can use 'Candidate ID' column as Source, Exam column as Destination, and count of Grade as Weight on the Sankey chart like below. It's easy to see that 00001 sits both Basic and Intermediate exam, 00002 just sits Basic exam one time, and 00003 sits Basic exam for two times. Smiley Happy

 

sankey1.PNG

 

Regards

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors