Page Break on Common Field with Two Tables

[jbarker95]

I'm attempting to create a report that has the following properties:

1. Uses data from Power BI Semantic Data Model
2. Combines data from two fact tables (1. survey responses and 2. site notes) and two dim tables (1. suppliers and 2. negotiation issues)
3. Has two tables on each page, one dedicated to each of the fact tables
4. Page breaks on the negotiation issue and has both tables on a single page

Ideally, users would select a supplier (only ever one) and a negotiation issue (either one, multiple, or all) and a report would be created that has both the survey responses and the site notes on one page broken up by negotiation issue.

The supplier and issue are parameters selected from DIM tables, and each table has filters to only return data for the parameter selections.

The problem I'm running into is the page break will split up all the notes first and then all the survey responses, but I'd like the notes and survey responses for each negotation issue on one page before page breaking to the next issue.

Below is an example of my current report:

Is this possible? Any advice is appreciated.

[divyed]

Hello @jbarker95 ,

Here are some steps you can follow :

1. Add survey response to both the table 

2. Create a group on survey response (both the tables)

3. Add a page break between each group by selecting option "Between each instance of a group" under row group properties

Please note, survey response should be a filter to both the tables

It should solve your issue.

Did I answer your query ? Kindly mark this as solution if this helps .

Cheers

[jbarker95]

Hi @divyed ,

Thanks for the response! Just to clarify, the page break should happen on negotiation issue, not survey response. Are the instructions still the same above? Survey response is only a field on one of the fact tables, while negotiation issue exists in both and is selected via a DIM table value set as a parameter.

I did try using your logic above with negotiation issue, but it is still splitting up the page breaks (doing all of site notes first and then all of survey responses second).

Below is what it should look like (grouped on company strategy, in this case I've selected one, but if I selected multiple issues, it should keep them on a page together before page breaking to the next one):

but this is what I get when I do the page break between each instance of the group (and have multiple issues selected:

It breaks up the site notes and survey responses on different pages.

[divyed]

Hello @jbarker95 ,

Yes logic will be same. As you have 2 parameters to filter the tables,use both parameters in group by and it should work. Logic and steps will be same.

I hope this helps.

[divyed · Accepted solution]

Hello @jbarker95 ,

You can try this method if still having issues with previous method . I have tested as well and working fine.

1. Add parameters to your report and populate using datasets as usual

2. Go to report designer => Add a list 

3. Place 2 tables (which you want to show on each page) within the list and populate using fact tables . Please note , It should have columns from parameters like in previous method

it should look like 

4. Click on List (not on tables) , go to details and add a row group . Pass your multivalued 

   parameter in the group 

5. Go to group properties and add page break between each instance of group.

It will work and will give desired result.

Example :

I have two paremeters for Category and Subcategory where subcategory is multi valued.I have passed subcategory as group and here are the result:

Cheers.

[jbarker95]

Lists is exactly what I was looking for, thanks!