Forum Discussion

TCavins's avatar
TCavins
Icon for Helper V rankHelper V
6 years ago
Solved

.Net repeater functionality in Power BI?

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

 

 

 

 

8 Replies