Forum Discussion
Visual idea help
Can you help me with your idea? I uploaded the sample excel and PBI file here: PBI community files
I think I should create 2 table, one for the training id-s and one for the prerequisite requirements, and should list all the prerequisite training id-s for 1 training. The structure of the data is wrong I reckon (that I have a prerequisite level for one training - which can mean 10-15 prerequisite trainings), I would need all the prerequisite training id-s for one training id. What do you think?
Thank you for providing the sample data. That helps a lot with proposing a potential solution.
Something like this?
or more aggregated like this?
Thank you for your advice!
I need similar design as the first pic you sent, but it would be important to visualize the connection between the trainings (so not just the levels). I mean I have to show what the prerequisite trainings of each training are (so what are the prerequisite trainings for the level 4 trainings). So, we need more „columns” to be shown.
My solution would be the below at the moment. But the problem with that is that I can’t see the prerequisite training IDs, if they are on the same training level.