Forum Discussion
Show full table in visual dynamicly based on filter
Super UserI am having 50 tables in my reportCombine them all into a single table. Include an identifier column "Type" that holds the distinction Customer/Vendor/etc. Use that column for filtering.
The column headers are different, for each of the 50 tables.
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.
- 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.
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".