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
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?
As in where the graphs are constructed and pinned. That's a shame.
Is it possible to add calculated fields into certain 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.