Forum Discussion
Dynamic Pie Chart Based on Slicer Selection containing data source table name
nikhil18 what Idrissshatila suggested would work, but if I have to do this, I will add another column in each table, let's call it "Type" and give the values "Type 1 " and "Type 2", and then append these tables. All this is easy to do in Power Query. Once done, you will have one table with data from both tables with a column called Type. Now you can easily setup a slicer on this new column which will filter the data based on the selection.
Hello nikhil18 ,
you could group both columns from both table in field parameters and you could rename it as you want , then users could switch between these two columns.
check it out https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Idrissshatila Thanks for the reply but i dont want to switch between 2 columns, i want to create a filter which could switch between 2 tables. Based on the selection of the table name the data from that table should be populated in the graph.