Forum Discussion

kormosb's avatar
kormosb
Helper III
4 years ago

Visual idea help

Hey Guys,   I would like to visualize the following. I have different kind of trainings which have prerequisite trainings in the following table. So we have training ID-s (every row different), a...
Need Help
kormosb's avatar
kormosb
Helper III
4 years ago

And how can I create more "columns" in the sankey chart for all the training levels?

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Sankey works on pairs of data.  Basic to Intermediate, Intermediate to Advanced etc. For each possible combination provide the number of users who completed that path (for example) and the Sankey will do the rest.

    • kormosb's avatar
      kormosb
      Helper III
      4 years ago

      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?

      • lbendlin's avatar
        lbendlin
        Super User
        4 years ago

        Thank you for providing the sample data. That helps a lot with proposing a potential solution.

         

        Something like this?

         

        or more aggregated like this?