Forum Discussion

samye228's avatar
samye228
Helper I
1 year ago
Solved

Report - Create tabs automatically

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

 

Need Help
  • parry2k's avatar
    parry2k
    1 year ago

    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.

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    1 year ago

    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.

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    1 year ago

    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!

     

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    1 year ago

    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.