Forum Discussion
new page when data changes in data
i'm looking to turn data like this:
| site | schoolYear | student | course | grade |
| Site A | 2023-2024 | Student A | Math | A |
| Site A | 2023-2025 | Student A | Science | B |
| Site A | 2023-2026 | Student A | History | A |
| Site B | 2023-2024 | Student B | Geography | C |
| Site B | 2023-2025 | Student B | Gym | A |
| Site B | 2023-2026 | Student B | Health | A |
into 2 separate pages like this:
i need to setup the page break when the student changes from Student A to Student B
how do i do this using Power BI Report Builder?
2 Replies
Hi meyersmike,
1. Click on View Menu and check Grouping.
2. Select the tablix in which you have this data.
3. Go to Row Groups and then "Details".
4. Right click on "Details". Select Group Properties.
5. In the window>>General>>Group expressions: Add>> Group on >> Either select from dropdown or use expression builder to add "Student" column( in which you have Student A & Student B) here.
6. In the same window>>Page Breaks>>Check "Between each instance of a group". and click on OK.
7. Then you'll get the desired output.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi KVRKarthik ,
when i do the above, i get 2 pages, which is correct, but unfortunately, only the first row of data is returned per student. also, i notice that on page 2, the table headers aren't included, even though i have repeatColumnHeaders set to true in the tablix properties
thoughts?
