Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
samye228
Helper I
Helper I

Report - Create tabs automatically

‎09-30-2024 09:12 AM

Hello,

I have a report for a building site and the buildings located on that site. I have a tab for the site and a tab for a building. I would like a macro? or DAX query or something to execute for Power BI to prompt me for the number of buildings on the site and  create a tab(s) from the building tab for each of the site's buildings. Can this be done?

Thank you,

Carol

 

Labels:
Message 1 of 4
524 Views
1 ACCEPTED SOLUTION
parry2k
Super User
Super User

‎09-30-2024 09:16 AM

@samye228 unfortunately it is not possible, but you can do this in a paginated report I am not sure if that is what you are looking for.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

Message 2 of 4
517 Views
0
3 REPLIES 3
Kedar_Pande
Super User
Super User

‎09-30-2024 11:41 PM

@samye228 ,

Power BI doesn't support automatic tab creation with DAX or macros.

 

 

  • Use Drillthrough: Right-click a building on the site page to view its details on the building tab.
  • Use Slicers: Have one building tab and use a slicer to select and display data for different buildings.

 

Message 4 of 4
477 Views
0
Uzi2019
Super User
Super User

‎09-30-2024 11:31 PM

Hi @samye228 

 

The solution your looking is quite not possible like creating an automatic tabs based on building and sites.

 

I hope I answered your question!

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Message 3 of 4
478 Views
0
parry2k
Super User
Super User

‎09-30-2024 09:16 AM

@samye228 unfortunately it is not possible, but you can do this in a paginated report I am not sure if that is what you are looking for.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 4
518 Views
0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All