Forum Discussion
.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
- TCavins
Helper V
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
Most Valuable Professional
- v-lili6-msft
Community Support
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