.Net repeater functionality in Power BI?

[TCavins]

I have a few tables, lets call them A, B, C, D, and E. There will only be one row from A. There could be multipe rows from B for the record in A. Multiple rows in C for each record in B. Multiple rows in D for each C and multiple rows in E for each D.

I simply want to display the data in a paragraph form as a sort of loop. I don't want a matrix that needs to expand. I just want a dump of the data in a way I can format it.

A

For each B in A

   For each C in B

      For each D in C

         For each E in D

For example state, county, city, high schools:

Michigan

   Wayne County

      Detroit

         Renaissance High School

         Detroit Denby

      Allen Park

         Allen Park High School

      Hamtramck

         School Name Here

   Oakland County

      Oxford

         Oxford High School

      Troy

         Troy High

         Troy Athens

Can this be done in Power BI? I know in .Net I would have repeaters inside of repeaters to display this.

Thanks

[v-lili6-msft]

hi  @TCavins 

You could create the relationships for these tables and  then use drill mode in power bi get it.

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

Regards,

Lin

[mwegener]

Hi @TCavins ,

but would a fully expanded matrix be okay?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[TCavins]

Possibly. When I do it though, I don't like that everything is shifted so far to the right when I'm down to the last level of detail. I lose so much real estate on the screen as the majority of the data is deeper in the hierarchy. This  pushes it down and far to the right.

Any options to alter the matrix cell positions?

[mwegener]

Try this

PBIX

[TCavins]

Thanks. While that works, I don't know if it will be good enough for end users to fully understand once it is fully populated. I think I need a way to put headers in on top of each sublevel of the hierarchy similar to the images below to let the users know as they are scrolling, what section they are in. It would require styling to distringuish each level from the section above and below. I don't see a way to do that in a matrix or apply a header section for Coutnties, Cities and Schools.

Michigan

    Counties

    Oakland

        Cities

            Troy

                Schools

                    Troy Athens

                    Troy High

            Oxford

                Schools

                    Oxford High

    Wayne

        Cities

            Detroit

                Schools

                    Detroit Denby

                    Renaissance

            Hamtramck

                Schools

                    Hamtramck High

[mwegener · Accepted solution]

[TCavins]

Thanks, this may be the best option using a Matrix. Not as pretty as nested repeaters in .Net but it's also not equivalent in Power BI.

[mwegener]

If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.