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.

     

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.