XML Groups and Sub Groups

[tonyororke]

I ham using XML documents as data sources in Power BI. Each documents consists of groups and sub groups.

I am trying to create a report using a matrix/table to display the data as below  I'm having issues presenting it in this way, mainly as I cannot get the the values from both Groups, and Sub Groups to display in individual columns.  

Any advice?

[lbendlin · Accepted solution]

XML documents are hierarchical.  Tables are flat.  Rethink what you are actually trying to achieve, and then change your Power Query code accordingly. (Look at the Fill Down  function, for example)