You can resize the chart using the handles around the edge of the visual. Using fields in Power BI visualizations is similar to how you work with PivotTables in Excel.ĭrag the Product Category field from the Products table into the Legend area, and the Total Revenue measure from the Sales table into the Values area. We will be interacting with these next to specify what data should be displayed and how.Ĭlick the arrow to the left of the Products and Sales tables to expand the list of fields. More options have also appeared in the Visualizations pane. Add the Pie chart to the reportĬlick the Pie chart button in the Visualizations area.Ī Pie chart is added to the report page. This ensures that no existing visualizations are selected when we go to create our new one. If you are not there already, you need to navigate to this view by clicking the Report button along the left side of the window.Īfter navigating to this view, it is a good habit to click somewhere within the white area. You need to be in report view to create your visualizations. The sales fact table has two measures which we can use in our visuals Total Revenue (a sum of the Total Sales field) and Average Sales Total (an average of the Total Sales field).ĭownload the file used in this tutorial to practice and follow along: This model consists of a fact table containing sales data and three dimension tables (Products, Customers and Sales Reps). We will be using the simple data model below.

You can easily create charts and other visualizations on a dashboard that can interact with each other.īefore we can create a Pie chart, we, first of all, need some data.įor the purposes of this article, the data has already been imported, relationships built and the measures have been created.

You have access to the powerful DAX language for creating measures.

It enables you to work with huge volumes of data and the calculation time is fast.

The big benefits of using Power BI are that: The free version is an all-in-one powerful business intelligence tool and will be used in this article. There are paid versions which provide more security and sharing options for businesses. To get started you first of all need to download Power BI desktop for free on your Windows device. The methods available to you for sharing depend on the version of Power BI that you have. These reports can then easily be shared with others.

Power BI is a business analytics service that enables you to get data from almost anywhere, transform it, model it and then create visually stunning and interactive reports.

Chart filters in excel for mac