Show full table in visual dynamicly based on filter

[Ken_Berg]

Hi Guys. 

Hopefully you can help me out.

I have a table with 2 rows containing 1 column called [Tablenames]. The values are  'Customer'and 'Vendor'. 
I have 2 more tables containing the actual data themselves: tables [Customer] and [Vendor]. 

Is it possible to use 1 visual, that shows the full [Customer]table when filter [TableNames] contains 'Customer' or the full [Vendor]table when filter [TableNames] contains 'Vendor' 

This example has 2 tables in total. I am having 50 tables in my report. i would like to create a drilltrough that brings the tablename to the next page and there shows the full table defined in the filter. 

Thanks! 

[lbendlin]

I am having 50 tables in my report

Combine them all into a single table. Include an identifier column "Type"  that holds the distinction Customer/Vendor/etc.  Use that column for filtering.

[Ken_Berg]

The column headers are different, for each of the 50 tables. 

[lbendlin]

What is your audience?  Are these data scientists? Sales ? Marketing? What's the business purpose of the report?

It may be easier to train your users on how to use Power BI Desktop, how to load data, how to use the data view, and how to personalize visuals.

[Ken_Berg]

i am using it to give insights in data quality of datasets that i have to migrate to a new ERP system. Long story short, my audience is the group of data owners / key-user group of the new ERP.

[lbendlin]

Yeah, just teach them how to use Power BI Desktop, and let them take care of the rest.  Don't waste your time trying to "fight the API".

[Anonymous]

Hi @Ken_Berg , hello lbendlin, thank you for your prompt reply!

Power BI does not inherently support dynamically switching entire data tables based on slicer.

Each visual requires a predefined data source, and it does not allow for dynamically changing the data source or table based on a condition.

This means you cannot directly switch between displaying the [Customer] table or the [Vendor] table based on the selected [TableNames] value. 

Best regards,

Joyce

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