If you have tried creating charts and graphs for your data in Excel, then creating reports in Power BI is even easier.
The retail analysis sample is composed of data about retail sales of items sold across multiple stores and districts. There’s also data about this year’s performance, last year’s sales, units, gross margin, variance, and others.
Now, you want to know and make a report about the total sales this year per item category.
Now, there are 2 ways to achieve that. You can either:
- Select the fields first then visualizations after
- Or if you have the specific visualization in mind, select the type of visual first then the fields after
We’ll go with the first method.
To start, focus your attention on the fields pane.
Select “Sales” and then “Total Units This Year”:
Select “Item” and then “Category”:
While clicking those fields, a visual will appear on the canvas:
Cool, right? Creating a report has never been this easy.
But now, you think that a pie chart is a better visual for your data.
To change the type of visual, just head over to the visualizations pane and click the pie chart icon:
Now you got your report in the visual type you preferred.