Microsoft Power BI Cookbook

Publish and pin excel objects

1. Open a new Excel workbook and select Connect to Data from the Power BI tab (Power BI Publisher for Excel).
2. Choose the Power BI workspace and dataset to be used as the source for the Excel report.
3. Click Connect and a blank pivot table will be created with the field list exposed on the right.
4. Create and format a pivot table. Apply a slicer based on a dynamic date column, such as current year.
5. Create additional slicers, such as Sales Territory Country = Australia:
   • To create a slicer, right-click a column in the field list and select Add as Slicer

Using slicers rather than the filters field well for pivot tables allows for a better presentation on the dashboard tile.

6. Select any cell outside of the pivot table, ...