Making Dynamic Table Reports

[Anonymous]

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_7, col_8, col_9

We need to show the table contents of table 1 and table2 without creating separate structure for both tables.

Showing the table1 contents at a time and showing the contects of table3 and similarly when clicked on a filter or a slicer

(Not BUTTON) 

Is it possible?

[amitchandak]

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

@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 · Accepted solution]

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.