CODEWITHSUNDEEP
reporting-servicesformattingpowerbireportbuilder
Chicxen
Chicxen

Reputation: 63

Table within a Table | Power BI Report Builder

When writing expressions for a row in Power BI Report Builder, things line up just fine until you get data that is a lot of text.

This is a prime example

enter image description here

I have 'cangrow' to true on all of my individual cells as well as the row group / row itself. Nothing seems to fix this. Is there any way to do this so the rows expand accordingly?

Ideally, I'd something like this.

enter image description here

EDIT: I believe the real problem is that I wasn't using a subtables because subtables look really bad when there are column groupings that block the merging of cells.

I'm now trying to find a way to basically add a completely separate table beneath the top table but still connected to be reported each match. First step would be find a way to have a separate data source in the subtable. Step two would be to allow the formatting of the subtable without the structure of the first.

I can't extend the subtable to the final column because of a required column group. And my expressions can't really do what I need them to without changing the dataset to something other than the main table.

Thanks for the help!

enter image description here

enter image description here

FINAL EDIT 2:

1) To resolve the separate dataset problem, I had to write a disgusting query to join the two sets I was using into one. I'm not sure there is a way to do that with Power BI Report Builder, although there should be.

2) I had to put the two separate tables into a list so they would be okay with formatting.

Got my problem solved, but in a round about way.

Upvotes: 3

Views: 742

Answers (1)

Chicxen
Chicxen

Reputation: 63

1) To resolve the separate dataset problem, I had to write a disgusting query to join the two sets I was using into one. I'm not sure there is a way to do that with Power BI Report Builder, although there should be.

2) I had to put the two separate tables into a list so they would be okay with formatting.

Got my problem solved, but in a round about way.

Upvotes: 2

Related Questions