Add visuals to a Power BI report (part 1)
These visuals can be created and viewed in both Power BI Desktop and the Power BI service. The steps and illustrations in this article are from Power BI Desktop.
This article gives a quick introduction to creating a visualization in a report. It applies to both the Power BI service and Power BI Desktop. For more-advanced content, see Part 2 of this series. Watch Amanda demonstrate a few different ways to create, edit, and format visuals on the report canvas. Then try it out yourself using the Sales and Marketing sample to create your own report.
This tutorial uses the Sales & marketing PBIX file.
From the upper left section of the Power BI Desktop menu bar, select File > Open
Find your copy of the Sales and marketing sample PBIX file
Open the Sales and marketing sample PBIX file in report view .
Select to add a new page.
Add visualizations to the report
Create a visualization by selecting a field from the Fields pane.
Start with a numeric field like Sales > TotalSales. Power BI creates a column chart with a single column.
Or, start with a category field, such as Name or Product. Power BI creates a table and adds that field to the Values well.
Or, start with a geography field, such as Geo > City. Power BI and Bing Maps create a map visualization.
Change the type of visualization
Create a visualization and then change its type.
Select Product > Category and then Product > Count of Product to add them both to the Values well.
Change the visualization to a column chart by selecting the Stacked column chart icon.
To change the way the visual is sorted, select More actions (...). Use the sort options to change the direction of the sort (ascending or descending) and change the column being used to sort (Sort by).
Continue on to: