Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Chris2038
Frequent Visitor

Standard Month-End Reports in Word

First time poster here,

 

For month-end reports, I keep having to paste visuals (snippet tool) into a word document, and then provide commentary underneath or around the visual.  These visuals I paste are almost entirely Power BI dashboards.  They are always in the same spot each month. The only thing that changes is the content. 

 

Does anyone have any suggestions on how to automate this? I understand there is a Pageinated view but unsure of how that works.

 

What I'd like to know is if there is a way to create a template of some sort that can be created and/or a report creation tool. 

3 REPLIES 3
Nathaniel_C
Super User
Super User

Hi @Chris2038 
Check out this video, it might take you to the path that you want to follow.
https://www.youtube.com/watch?v=lqlYl3pVL1g 

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thanks Nathaniel. Perhaps it is worth it for me to learn the pageinated view since the power BI content directly flows to a word template, which I can have saved.

 

Before I go on to learn this, does the report allow for date changes? For example, if i link a treemap visual over to word for monthly sales and I need to change the date filters, what are the steps to take in word and/or Power BI?

AllisonKennedy
Super User
Super User

@Chris2038 Paginated reports is a steep learning curve and requires Premium licensing. It also won't let you put it in a Word doc easily.

 

There's an Export to PowerPoint function that you may find helpful. I would recommend creating a report with one visual per page. Then Export to PowerPoint and you can then copy those visuals to your word doc, or just use the PowerPoint as your report instead of Word.

AllisonKennedy_0-1637720106162.png

 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.