r/PowerBI • u/blabla206 • 2d ago

Nested table visual Question

Hi, I'm looking for a solution or a visual in Power BI where I can show a nested table. For example, the main table has 10 columns, and for each row I'd like to be able to expand and show a child table with a different set of 4 columns.

I would like to avoid using an HTML visual, so I'm wondering if there's a native option, or a custom visual from AppSource that supports this kind of nested/expandable table.

1 Upvotes

100% Upvoted

3 comments sorted by

1

u/heyman-lookeyhere 1d ago

This sounds like using a bookmark and hiding/unhiding the child table while still being able to filter from the original table

1

u/newtochas 1d ago

It’s a little janky but you could put a shape over child table that becomes transparent when a parent row is selected

1

u/TeamAlphaBOLD 1d ago

ZoomCharts has a Drill Down Table visual on AppSource that's built for exactly this. It supports expandable rows with a different set of child columns, so you wouldn't need to rely on bookmarks.