Forum Discussion
tonyororke
Helper II
Helper IIXML Groups and Sub Groups
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?
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)
1 Reply
- lbendlin
Super User
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)