Break a Table into thirds

[Anonymous]

So I have a table with about 37 entries on PowerBi Report Builder. What I want to do is cut this table into 3 different tables so that I have 3 tables with 13 items on each table. I have searched and found someone that did the same however, they didn't share their solution. Has anyone successfully done this before, if so would you share what you did to make it happen thanks!

Also, one other thing I'm trying to do, I have an expression that counts the number of rows within the table however I have 3 tables that produce an empty row at the end and the expression i have is counting all of the rows, event he empty ones. I've hid the empty rows but they're still getting counted. Is there something I can add to my expression that would exclude empty rows?

current expression used : CountRows("DataSet")

[Anonymous · Accepted solution]

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.

[Anonymous · Accepted solution]

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.

[Anonymous · Accepted solution]

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.