Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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:
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.
Solved! Go to Solution.
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.
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.
@Anonymous , Check of some custom tables can help
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?
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 57 | |
| 38 | |
| 34 | |
| 18 | |
| 16 |
| User | Count |
|---|---|
| 70 | |
| 66 | |
| 42 | |
| 32 | |
| 25 |