Power Platform Community Forum Thread Details

I have a Power BI report with various metrics for different teams within my department. The report, which is divided into several pages, can be sorted by using the dropdown on the first page labeled "Team Name." This dropdown allows you to check off the respective team whose metrics you want to view, and the pages will filter the data accordingly. See below for an example with the team names blacked out.

I have a PowerAutomate flow that I am using to export PDFs of each team's metrics and send to myself via email.

The flow is as follows:

However, what this does is export PDFs of just the default view of the dashboard, so the first page of the dashboard with all the team names checked off as "Select All." It exports the PDFs as "[team name].pdf" but the actual content is wrong. What I need is to have all pages in the dashboard exported and sorted by team, and each PDF is divided by team data. Not sure what I'm doing wrong here but any advice is appreciated. I am a complete Power Automate novice

Categories:

Building flows

@JL-27070542-0

It sounds like you're using a Power BI slicer (dropdown) to filter data across multiple report pages by "Team Name" — which is a great way to create a dynamic, team-specific experience.

To ensure that the slicer selection applies across all pages, here are a few key things to check:

✅ Ensure Slicer Sync Across Pages

Use the "Sync Slicers" feature:
- Go to the View tab in Power BI Desktop.
- Click Sync Slicers.
- Select the slicer (e.g., "Team Name") and ensure it's synced across all relevant pages.
- You can choose whether the slicer is visible or just synced in the background.
Use a single source for filtering:
- Make sure all visuals on all pages are using the same "Team Name" field from the same table.
- Avoid duplicate or unrelated fields that might break the filter context.

🧩 Preserve Query Parameters or Record IDs

If you're navigating between pages and want to preserve specific filters like record IDs or query parameters, consider:

Using Bookmarks with slicer states saved.
Creating drillthrough pages that pass context (e.g., team name or record ID).
Using dynamic titles or filters to reflect the selected team.

🔄 Power BI + PowerApps Integration

If you're integrating PowerApps into your report:

Make sure the PowerApps visual receives the filtered data from the slicer.
Use PowerBIIntegration.Data in PowerApps to access the filtered dataset.

🏷️ Tag me if you have any further questions or if the issue persists. ✅ Click "Accept as Solution" if my post helped resolve your issue—it helps others facing similar problems. ❤️ Give it a Like if you found the approach useful in any way.