Two-dimensional Pivot Table

If you drag a field to the Rows area and Columns area, you can create a two-dimensional pivot table. First, insert a pivot table. Next, to get the total amount exported to each country, of each product, drag the following fields to the different areas.

[mai mult...]

Create a graph in Excel

 There are three basic types of graph that you can create in Excel, each of which works best for certain types of data:

  • Bar – Displays one or more sets of data using vertical bars. Best for listing differences in data over time or comparing two similar sets of data.
  • Line – Displays one or more sets of data using horizontal lines. Best for showing growth or decline in data over time.
  • Pie – Displays one set of data as fractions of a whole. Best for showing a visual distribution of data.
[mai mult...]

Connect your Excel workbook from OneDrive for work or school to Power BI

When you choose Connect, your workbook appears in Power BI just like it would in Excel Online. However, unlike Excel Online, you have some great features to help you pin elements from your worksheets right to your dashboards.

You can’t edit your workbook in Power BI, but if you need to make some changes, you can select Edit from the Workbooks tab of your workspace. Then choose to edit your workbook in Excel Online or open it in Excel on your computer. Any changes you make are saved to the workbook on OneDrive.

[mai mult...]

Create a copy of a dashboard in the Power BI service

There are many different reasons to make a copy of a dashboard. Maybe you want to make changes and test its performance against the original; or create slightly different versions to distribute by colleague, region, or team. Perhaps a colleague admires your dashboard design and wants to use it for reporting out to their managers. Another reason would be if you have a new database with the same data structure and data types and want to reuse the dashboard you’ve already created. This can be done but would require work in Power BI Desktop.

Dashboards are created and copied using the Power BI service and can be viewed in Power BI mobile and Power BI Embedded. Dashboards aren’t available in Power BI Desktop.

[mai mult...]