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

[ninja18]

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.

[v-jialongy-msft]

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.

[ninja18]

Yes

[danextian]

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

[Idrissshatila]

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

[ninja18]

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.

[Idrissshatila]

Hello @ninja18 ,

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

[ninja18]

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.

[Idrissshatila]

@ninja18 ,

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

[ninja18]

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)?