Forum Discussion

mmaine's avatar
mmaine
New Member
4 years ago

Conditional flow-chart (or some other term) Seeking Advice

Hello, All!

 

I am new to Power Bi, but catching on quickly.  I have an interesting challenge that I am hoping someone has some expert guidance or suggestions to help me, or to just tell me I'm crazy. That's okay, too. 

 

Context:   I work at an school and students are required to meet certain requirements to graduate.  These are typically involving test scores or completed courses.   I have all this data in various csv or excel sources. 

 

Goal:    A visual report showing the "path" that a specific student has met his/her graduation requirement.   The shortest possible, preferrably.    I envision something that looks like a flow chart that is generated after selecting the student.  

 

Thoughts:    The requirements to graduate are not entirelly simple and has a lot of layers.  Building something with nested IF statements seems daunting considering the sheer number of "paths" a student can qualify for graduation.    If you are curious for specifics, here is a guide on the requirements and the many paths a student can take. See Page 4!

 

Am I crazy or is this doable?   Any thoughts or suggestions are greatly appreciated!