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.
parry2k Thanks for the reply. This will work but the two table i have are the bank trasactional data. For a month i have million of records in each table, if i append this table in real time it will not be an optimal solution plus it will also increase load. Is there any optimal way to do so?
Not sure why it is not going to be an optimal solution. What made you think so?
Regarding time with the append step, have your tried to check how much time it added? Inwijld
recommend to test it and then provide the feedback.
Thanks for your input, parry2k.
In our testing environment, I haven't observed any performance issues so far. However, as I can't easily replicate our production setup for testing, I'm cautious about potential challenges.
I'm not sure about the backend process in Power Query for appending data, but in traditional SQL with a UNION operation, this could lead to problems in production. To ensure we proceed optimally, I'd greatly appreciate your confirmation that this approach should work in a production environment. Your expertise would be invaluable in making this decision.
Looking forward to your insights. If you believe it's a viable solution, I'll move ahead with it.