Create automatically a new BI page for each unique value (item)

[Bakky02]

Hi all,

Let's say I would like to have an BI overview per item. The first page is about item bicycle and the related sales/purchase statictics. 

Currently I duplicate the page and filter per page on the right item. Is there a way that PowerBI can create automatically a page per item/value (and use the same visuals on each page).

Thanks a lot.

[Idrissshatila]

Hello @Bakky02 ,

yes, you can create one page and mark it as a drill through page on the item field.

in this case, when you drill through a certain item it will show it's data, and then when you drill through with another item it will show the second item's data only.

check it out https://youtu.be/BbplhqDCWOM?si=B96Jk-gGxF5rG_u7

[Bakky02]

H Idrissshatila,

Thanks for your comment, that's very interesting. Is there also a way that BI creates automatically 50 pages (1 for each unique item/value) and that during a refresh all pages are updated (instead of 1 drill down)?

Or that we can create a new page from a drill through, based on a default format. Then it might be an option to get a new page for each drill through. Thanks.

[Idrissshatila · Accepted solution]

Hello @Bakky02 ,

no, Power BI won't create pages automatically, and this is not efficient at all. The best efficient way is to make a drill through page.