Forum Discussion
Dashboard with multiple datasets
Hi all. Is it possible to build a dashboard with multiple excel files? E.g. 1 graph using data from excel file A and a second graph using data from excel file B...on the same dashboard
Yes it is very possible. You need to upload both excel models using Get Data. Then you can create reports/charts against each data set. Then you go to Dashboards and create a new one. Make sure you are in the new dashboard by clicking on its name, then you can click on the reports in the report section, mouse over charts you need in your dashboard and click on the Pin icon. Now you will have those charts pinned to your newly created dashboard and when you click on the dashboard tiles, you will be taken to the corresponding reports.
You cannot have two different datasets drive the same report however.