Hi,
I am trying to make a one-slider report in Power BI with a dropdown filter for choosing between showing data from different tables. It would be very simple and elegant to have data from all tables go into the same visuals, and then let a dropdown filter let you choose what table you want to show data from.
Lets say I have 10 factories that produce bottles, and I have imported data from each factory into separate tables, so 10 tables.
Each table has similar data fields, for instance one column of data is "bottles produced".
In one visual I put "bottles produced" field inserted from all 10 tables, so all are shown.
However I want to only show one at a time, and which one depends on a dropdown filter list which lets me choose "Factory 1", "Factory 2"... etc.
I am fairly new to Power BI, so I was thinking of making a separate list of factory names and connect each element in that list to its own factory's data table. So one list item connection to one table. I don't even know if that is possible. Then by putting that list of factories neames into a slicer I would hopefully be able to only see data from the table which that list element is connected to.
Hope this makes sense.
I figured I'd ask here because I cannot seem to find a condensed way to explain the problem for a web search.
