Solved: Re: Report - Create tabs automatically

samye228 · ‎09-30-2024

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

parry2k · ‎09-30-2024

@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

Kedar_Pande · ‎09-30-2024

@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.

Uzi2019 · ‎09-30-2024

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!!!

parry2k · ‎09-30-2024

@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.