Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Nested table inside table visual - is this possible?

I want to display a main table and subtable within the same visual. Is there a way to put the subtable into a column and display as a nested table, the way you can with html? Or even a nested list? The dependent table only displays the file upload date, but it's paired with an additional column that supplies the URL that makes the date a link. 

 

Right now it looks like this, with the selected value in the main table having 3 rows in the dependent table:

 

Main table:                                     Dependent Subtable:

aclark7020_1-1665536405810.png

If there's a better way to do it, I'm open to alternatives. I tried extracting the multiple values into a semicolon-separated list in order to get them into one column, but that didn't work well for turning them into links. I also tried a matrix with the dependent table as a nested row but that made all the other data repeat 3 times, see example below.  Ultimately I need a spreadsheet-like result that people can export and sort. 

 

aclark7020_2-1665537645262.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

End result of this quest, after a lot of research: Power BI is not HTML and is not built to handle nested tables the way I want. In the end I had to redesign my report to display the 1-to-M relationship in 2 separate table visuals, and my customers will just have to get used to it. 

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

End result of this quest, after a lot of research: Power BI is not HTML and is not built to handle nested tables the way I want. In the end I had to redesign my report to display the 1-to-M relationship in 2 separate table visuals, and my customers will just have to get used to it. 

amitchandak
Super User
Super User

@Anonymous , Check of some custom tables can help

https://xviz.com/visuals/hierarchy-variance-table/

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=hierarchical%20table&page=1

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Anonymous
Not applicable

I went through all of the links you suggested and sorry to report I didn't see the connection with what I'm trying to do. It all seems to be about statistics and summary-level computations. Probably I'm just not an advanced enough user to see how to apply these tools to created a nested subtable within a column. But I will keep experimenting. And alternative ideas are still welcome! 

Are you just trying to pull the date/time stamp into the table visual as a column and not part of the hierarchy that your capture is showing?

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.