how it make in power bi page break like in SAP web intelligence

[Anonymous]

I have a 2 page report that I filter by country and by product on the first page. And on the second page it shows me the kpis associated with that product.

What I want is that when I filter by country in the first page It creates as many pages of kpis as there are products in that country filtered

pd: the report is in direct query mode also not all countries sell the same or the same number of products

[TomMartens · Accepted solution]

Hey @Anonymous ,

creating dynamic pages using Power BI is not possible.

You also can create an idea on ideas.powerbi.com

If you are backed by a premium capacity, you can check if the Subpage feature of paginated reports fits your needs, support of this feature has been announced lately. Read about it: https://powerbi.microsoft.com/en-us/blog/subreports-now-available-for-paginated-reports-in-power-bi/

Even if this does not create what you are looking (a single report page for each product), you can consider placing a slicer on the 2nd page using the product column, assuming you have a dedicated product table connected to your fact table, you can use a measure to reduce the products shown in the slicer: https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/

Regards,

Tom

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

There are two similar ideas that you could vote up.

Dynamic page break feature 

Dynamic page break feature 

In addition to synchronizing slicers, you also could try drill through in the report.  When we right click the value to choose drill through, it will jump to the other pages automatically. For more details, please take a look at the documents:

Set up drill through in Power BI reports 

[TomMartens · Accepted solution]

Hey @Anonymous ,

creating dynamic pages using Power BI is not possible.

You also can create an idea on ideas.powerbi.com

If you are backed by a premium capacity, you can check if the Subpage feature of paginated reports fits your needs, support of this feature has been announced lately. Read about it: https://powerbi.microsoft.com/en-us/blog/subreports-now-available-for-paginated-reports-in-power-bi/

Even if this does not create what you are looking (a single report page for each product), you can consider placing a slicer on the 2nd page using the product column, assuming you have a dedicated product table connected to your fact table, you can use a measure to reduce the products shown in the slicer: https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/

Regards,

Tom