Reply
ninja18
New Member
Partially syndicated - Outbound

How to dynamically generate multiple page report (different filters) from single page PBI dahbaord?

Hi,

 

Is it possible to generate a multiple page report dynamically (each page for each state - state is available as a filter on PBI dashbaord)? Idea is to generate a 52 page report from a single page PBI dashboard. I wanted to know if there is any easy way to do it rather than creating 52 pages. Business requirement is not to create a 52 tabs, they want 52 pages. Please advise me.

9 REPLIES 9
v-jialongy-msft
Community Support
Community Support

Syndicated - Outbound

Hi @ninja18 

Do the 52-page reports you need have the same content, with only the filters or slicers being different?

 

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Syndicated - Outbound

Yes

danextian
Super User
Super User

Syndicated - Outbound

They want 52 pages of the same page?  That will be a maintenance nightmare.





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

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


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Idrissshatila
Super User
Super User

Syndicated - Outbound

Hello @ninja18 ,

 

the only way is to prepare the first page and then duplicate it and change the filter for every page.

 

you can duplicate it easily as the following

Idrissshatila_0-1733942560203.png

 

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Syndicated - Outbound

Thank you,

 

Business doesnt want to have 52 tabs, they want to have 52 pages to scroll and then eventually to export to PDF. I am trying to explore if there is an option to do it dynamically or even okay to create 52 pages, but not tabs in PBI dashboard.

Syndicated - Outbound

Hello @ninja18 ,

 

why dont you have a filter slicer that would change and it would affect on the pages result.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Syndicated - Outbound

Sorry if I missed it earlier. The dashboard already has a state filter, but I am stuck here on how to create a 52 page report from this single PBI dashbaord.

Syndicated - Outbound

@ninja18 ,

 

I honestly couldn't understand your need, can you show us an example of what you want.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Syndicated - Outbound

Sorry for late reply,

 

There is a US sales dashboard and it has state filter. Is there any way I can generate a 52 page report from that single page dashboard? Each page is for each state- without duplicating the dashboard to 52 tabs (each tab with each state filter)?

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)