Break a Table into thirds

Hi Anonymous ,

For your problem, let's solve it one by one, your requirement is to divide a table with 37 columns of data into three tables with 13 columns each, we can do the following:

Select the Data Source you want to use and then select Add Dataset:

Then select query designer in the interface to operate on the tables you want to group.

Due to the limitations of the Power Bi Report Builder, it can only be grouped one by one using manual grouping.

or your second question about how to exclude empty lines, you might try adding the following filters to your expression, which might help you.

=IIf(Not(IsNothing(Fields!Type.Value)),CountRows("DataSet1"),0)

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

So, here's how I solved the table being broken into 3 separate tables. 

I created a dataset with my Title and Date Reported, I added in my filter Range(Inclusive) to start from the first entry down to the 13th Entry. Then saved that query and added the table to my paginated report. I just repeated that in the following 3 datasets starting with the entry after the last one that was placed in the previous table query.