Part 2, Add visualizations to a Power BI report (Tutorial)
In Part 1, you created a basic visualization by selecting checkboxes next to field names. In Part 2 you'll learn how to use drag-and-drop and make full use of the Fields and Visualizations panes to create and modify visualizations.
Create a new visualization
In this tutorial we'll dig into our Retail Analysis dataset and create a few key visualizations.
Open a report and add a new blank page.
Open the workspace where you saved the Retail Analysis sample. Select Retail Analysis Sample to open the report in Reading View.
Select Edit Report to open the report in Editing View.
Add a new page by selecting the yellow plus icon at the bottom of the canvas.
Add a visualization that looks at this year's sales compared to last year.
From the Sales table, select This Year Sales > Value and Last Year Sales. Power BI creates a column chart. This is somewhat interesting, and you want to dig deeper. What do the sales look like by month?
- From the Time table, drag Month into the Axis area.
- Change the visualization to an Area chart. There are many visualization types to choose from - see descriptions of each, tips for best practices, and tutorials for help deciding which type to use. From the Visualizations pane, select the Area chart icon.
- Sort the visualization by selecting the ellipses and choosing Sort by Month.
Resize the visualization by selecting the visualization, grabbing one of the outline circles and dragging. Make it wide enough to eliminate the scrollbar and small enough to give us enough room to add another visualization.
- Save the report.
Add a map visualization that looks at sales by location
- From the Store table, select Territory. Power BI recognizes that Territory is a location, and creates a map visualization.
- Drag Total Stores into the Size area.
- Add a legend. To see the data by store name, drag Chain into the Legend area.
- For more information about the Fields pane, see The report editor... take a tour.
- To learn how to filter and highlight your visualizations, see Filters and highlighting in Power BI reports.
- To learn about using and changing aggregations, see Aggregates in reports.
- More about Visualizations in Power BI reports.
- More questions? Try the Power BI Community.