topic Re: Show full table in visual dynamicly based on filter in DAX Commands and Tips

Show full table in visual dynamicly based on filter

Ken_Berg — Fri, 27 Dec 2024 14:58:07 GMT

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!

Re: Show full table in visual dynamicly based on filter

lbendlin — Fri, 27 Dec 2024 16:01:35 GMT

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.

Re: Show full table in visual dynamicly based on filter

Ken_Berg — Mon, 30 Dec 2024 07:22:39 GMT

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

Re: Show full table in visual dynamicly based on filter

Anonymous — Mon, 30 Dec 2024 09:43:51 GMT

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.

Re: Show full table in visual dynamicly based on filter

lbendlin — Mon, 30 Dec 2024 15:11:48 GMT

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.

Re: Show full table in visual dynamicly based on filter

Ken_Berg — Mon, 30 Dec 2024 16:02:10 GMT

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.

Re: Show full table in visual dynamicly based on filter

lbendlin — Mon, 30 Dec 2024 16:45:36 GMT

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".