Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
wonka1234
Helper II
Helper II

Is it possible to create pages with table/card on them dynamically?

hi,

 

say I have a table with 3 records.  A column containing 'ID', and 3 rows.

ID
12345
56789
10112


is it possible to automatically create a page with each of these in a card on them?
issue is that these ID's can change each month. Ie next month may have id '22222' in addition to the previous 3.

I was thinking of power automate, but please let me know if you have any suggestions.

 

thanks.

1 ACCEPTED SOLUTION

So yes, you can filter each page with an Index so that if the ID changes it still have the new ID value.  If you have alot then you have to go through each page.  

Also you can just create everything on one page and just have a dropdown where the users selects the ID, think this much cleaner.

View solution in original post

6 REPLIES 6
v-pbandela-msft
Community Support
Community Support

Hi @wonka1234,

Thank you for reaching out in Microsoft Community Forum.

Thank you @Bmejia    for the helpful response.

As suggested by Bmejia, I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.

wonka1234
Helper II
Helper II

@Bmejia I wan tto create a page of each of my IDs.

next month, do the same thing, create a page for each of my IDs. 

Each page must have a card or table showing the ID.

So yes, you can filter each page with an Index so that if the ID changes it still have the new ID value.  If you have alot then you have to go through each page.  

Also you can just create everything on one page and just have a dropdown where the users selects the ID, think this much cleaner.

thanks! this makes sense. 

What are your thoughts on having users wanting to fill out text , lets say in a text box in each page?

They users can not fill a text box but you can create dynamic tittles so when they choose a ID.  They know what they are looking at. 
Simple example like this

Dyanmic Title = "This is the ID# " & SELECTEDVALUE(Q1[ID]) & " Selected"




Bmejia
Super User
Super User

I am not sure that I understand fully what you are trying to do , but the Page names can not be dynamically rename base on your ID or anythig else, what you can do is add and Index column to the ID list and filter each page by the each index.  make sure that you sort the table asc or desc so that at least there is an order to it.

Bmejia_0-1747857800525.png

 

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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