NewsLetter-Style

Question

Ok I just started creating reports in PowerBI Reporting, which is real close to SSRS, so I hope you guys can help me out with a report I'm trying to create. Bare with me if my question seems fuzzy, I'll try to add details if you guys can't understand the questions :

1. I'm trying to produce a report NewsLetter-Style on 2 columns. This report is going to be consumed as a way to produce label for mass mailing. So I got the 2 column part on my report done but what i'm trying to figure out is how to but a maximum of items block to be displayed by column. Right now I would like to fit 10 on each side and it has to line up perfectly. Is there a way to se a number of items by column ? Right now my setup is a List region containing 3 textbox with 2 of those having info from my dataset.
2. The first item in my second column starts a bit too high for some reason how can i fix that ?
3. I read on a Microsoft site that, for some reason, when you are exporting that report to Word you lose the 2 columns and it all goes on one column. How can I make a report that is going to retain the 2 column part so when can print those labels ? I tried exporting to PDF and from there exporting to Word and that works, but it's a process I would want my users to go throught.

I've attached a screenshot of my setup if it helps.

Thank you for the help

Answer 1

Hey @Jean-François Handfield ,

1.Please delete the 'sorting by' as shown in the first image.
If you want 20 per page like the second image show, you may use 'Ceiling((RowNumber(NOTHING)) / 10)' which means put 10.

2.Thanks for the "compiled" report, the issue is related with the table position.
Please adjust the position of your table like my third image setting, make the location top to 0in.

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

Answer 2

Hi @ZoeHui-MSFT

what is the solution on this?

was there any fix?