cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jimbok11 Frequent Visitor
Frequent Visitor

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
4 REPLIES 4
andre
Advisor

Re: Dashboard with multiple datasets

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.

Jimbok11 Frequent Visitor
Frequent Visitor

Re: Dashboard with multiple datasets

Oh yeah, I meant the same report.

As in where the graphs are constructed and pinned. That's a shame.

Is it possible to add calculated fields into certain datasets?
Super User
Super User

Re: Dashboard with multiple datasets

You can add calculated fields to datasets in their source data model, not after upload. So in Excel, if you used the Power Pivot data model, you can add calculated fields and calculated columns.

 

Reports are designed to be pulled from a single dataset while dashboards are the mechanism for combining visualizations from multiple datasets.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


luisrh Regular Visitor
Regular Visitor

Re: Dashboard with multiple datasets

You can bring in tables from any source into power query and then combine into one model (which ends up being a dataset in Power BI).   A great way to do this is to use M and the advanced editor in Power Query to mash up sources.   You can do it manually in Power Query and then look at the advanced editor in Power Query (either in Excel or Power BI Desktop) to understand how it generates the M for each table or mash up. 

 

check out this video to get an idea of what's possible

https://channel9.msdn.com/Series/Big-Data-Analytics/01