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 I'm a little lost with your reply. What is going to be the source when you are using the production environment? Is it still CSV files or any other source? Also, where these CSV files are stored? What is the size difference (records) between the Test and Production environments? How often Power BI dataset need a refresh, in other words, how often do these files get updated?
Thank you for your patience parry2k and for further clarifying the context. To make it more relatable, let me illustrate the issue with a simplified example:
In my testing environment, I used a static CSV snapshot containing one month's worth of data. However, in our actual production scenario, we will connect to an Oracle database, which will be refreshed every 30 minutes. This means that the data volume is significantly larger and more dynamic.
To give you a sense of the complexity, consider a real project where we could have not just two tables but potentially six or seven, each spanning six months' worth of transaction records. These tables could easily contain close to one million records each, with multiple columns.
Now, picture a Power BI dashboard featuring five to six interactive graphs, all in sync with each other. In this dashboard, I need to implement a filter that allows users to select a specific table name. When a table is selected, the corresponding data from that table should populate all the graphs on the page.
The challenge lies in efficiently handling this dynamic scenario where we're dealing with extensive, frequently updated data from multiple tables. I'm looking for an optimal solution to ensure our dashboard remains responsive and provides users with the data they need.
Your guidance and expertise in handling such complex setups would be greatly appreciated. Thank you for your understanding.