One record per page, multiple pages, filtered by previous week

[silverdale9999]

I'm trying to save some time for a team that are producing a bunch of Powerpoint slides each week for senior level reporting.

• Each slide has a template for one high profile Incident, which is populated with data that I already have in PowerBI.
• Only Incidents from a set date range are required (Previous Saturday to Friday)
• There may be multiple Incidents from a week, multiple per day, or maybe none at all. (There have never been more than 10 - risky assumption I know!)  I don't think PBI can dynamically create pages, so I am happy to have a set of say 10 pages prefilled with a template.. some of these may be blank.
• Each of these is differentiated by a unique ID

I can get the data in the correct place for one record, what I can't figure out is how to filter only one record per page automatically, to allow a simple 'export to powerpoint' to replace multiple copy and pastes from various places.

Any thoughts? I'm sure it's possible, just can't get my head around it!

Thanks!

[Anonymous]

Hi, @silverdale9999 

We have a third-party app that connects Power BI to PowerPoint (and Word, and Outlook) called PowerBI Tiles Pro that may help you. It includes a refresh option that updates the visuals in your presentation to the latest data while keeping all formatting. While not automatic, this removes the need for any copy/pasting if you need to update your presentations regularly. You can try it for free for an unlimited amount of time. Let us know if you need any help using it.

Best regards,

The DevScope team

[sturlaws]

Hi @silverdale9999 

you could create a rank column in your dataset, if you have something to rank them by. You could event rank them by your unique ID, I think. Then use the rank-column in the Page filter-pane of each page, filtering for rank=1 on the first page, rank = 2 on the second,...

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.