Creating a Dimension

Hi all,

I'm not sure if the question that I'm asking has been asked already as I am new and if it has then I am sorry.

I have extracted data from MS Visio to Excel and need to create a data dimension in Power BI and I tried creating hierarchies from the extracted but I'm having problems and I'm not sure if its the connectors or what, Please help

Thank you in Advance