Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Making Dynamic Table Reports

Dynamic reports which take any table structure into account and plot the graph and table accordingly. For Ex: Table1 has columns : col_1, col_2, col_3, col_4 Table3 has columns : col_5, col_...
Interesting Links
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

    I think you can try to append all tables as one table in Power Query and filter tables by slicer.

    Firstly, add [TableName] columns in each table by Custom column function in PQ.

    Such as Table1 add TableName = "Table1" ... And then add an Index column.

    Then Unpivot all your tables by TableName and Index column.

    Then Append all tables as one.

    Result is as below.

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , You have unpivot the tables or use bookmarks and buttons.

 

I doubt other options. As you are ruling out both

 

Dynamically change chart axis in Power BI
bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    amitchandak thank you for your answer,

    What if i had more than 100 tables with me like table1,table2 ....table100 ,It would not be correct to have 100 bookmarks and buttons?

    Will it be possible to have a solution or there is no other solution?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous 

      I think you can try to append all tables as one table in Power Query and filter tables by slicer.

      Firstly, add [TableName] columns in each table by Custom column function in PQ.

      Such as Table1 add TableName = "Table1" ... And then add an Index column.

      Then Unpivot all your tables by TableName and Index column.

      Then Append all tables as one.

      Result is as below.

      Best Regards,
      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.