Displaying multiple Tables with different number of columns into a single Table Visualization

[Fraz707]

Hi All,

I have been tasked to build a front end to show data from 3 different tables(tables sitting on Azure SQL DB) in single tab on Power BI dashboard.

The 3 tables are going contain 10, 15 and 17 columns respectively.

Number of records on these tables will never grow more than 300 records.

The only request is to have all 3 tables data made available in one tab – so that a button/visualization will allow the user to pick – which table data to be displayed/shown in the dashboard.

So the question that I have is

1. Can I build such kind of interface in Power BI ?
2. What controls should I be using to handle this hide/unhide kind of functionality ?

[v-easonf-msft · Accepted solution]

Hi， @Fraz707 

If help , try the  following steps:
Create three table  visuals -> create three buttons->create three bookmarks ->  link icons to  each bookmarks -> edit the visibility status of each object  in the Selection pane ,and update bookmarket

Here is a demo.

You can Ctrl + click to test the button in powber desktop.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy]

This is a totally different problem than what I imagined before your update - thanks for the clear explanation. 

In this case I would recommend using buttons and bookmarks. You can show/hide visuals and code that into bookmarks, then attach a bookmark to each button so they can select which table they want to view. 

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

https://medium.com/@arjunuttamsharma561/hiding-a-visual-from-report-dashboard-in-power-bi-9bc5bfc57b...

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv

[Fraz707]

Hi, I've updated the question.Hope you get it  now and can give some views on this.

@AllisonKennedy  @amitchandak 

[amitchandak]

@Fraz707 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
refer, if this can help

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[AllisonKennedy]

You'll have to give us a bit more info on why they need to be in one table. As you say, if column names and numbers are different, then what is it that connects them or why/how can they all be combined? 

Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 

If you found this post helpful, please give Kudos.

I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 

https://sites.google.com/site/allisonkennedycv