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.
nikhil18 there is a lot more involved than what you posted on the original question. First I would not worry much about 1 million rows etc.
First thing first, since you are using Oracle I will do as much data preparation as possible in Oracle. Having said that in this case, I will just create a view in Oracle that combined the tables together and Power BI is just bringing the data in for the visualization.
Once the data is uploaded in Power BI then from there interaction and everything will be super smooth. In this case, the main component is the resources are the Oracle servers are managed and a lot of it will depend on it. I'm not an Oracle admin and I cannot suggest what needs to be done on the Oracle side so that the view performs to provide the data efficiently.
All in all, it is going to be mix optimization, and Power BI will just need to bring the data in and visualize it. Again, it is not about million rows, and don't have that number take you off the track. I work with solutions where my customers have 500 million+ rows and fully optimized solution work very smoothly where volume is just a number.
