4. Creating Visualization

In the previous chapter, we loaded to data in Power BI desktop. In this chapter, we will create visualizations using that data.

Power BI report view contains multiple pages of reports. Each page can contain one or more visualizations.

In the report view, you can see that Power BI provides a rich set of visualizations.

To create a visualization, navigate to Report view, select a visualization of your choice and select fields.

Creating a Bar chart

Follow below steps to create a Bar chart

Steps:

  1. In Power BI desktop, navigate to Report view and from under Visualizations, select a bar chart. It is the second in the list of visualizations 
  2. On the canvas you will see a placeholder of the chart.
  1. From the Fields on the right, select Order Date and drag it to Axis. Since this is a date datatype field, Power BI has automatically created a hierarchy for you – Year, Quarter, Month and Day.
  2. Similarly, select Sales and drag it to Value.

This will create a bar chart, with Years on x-axis and Sales on the Y-axis. It shows Sales in each of the Years.

You can provide formatting to your chart, using the roller pin icon.

When you create a chart/visual using the fields, Power BI automatically create filters for you.

There are different kind of filters such as Visual level filters or Page level filters.

Hope this tutorial provided you a good starting point in becoming a Power BI professional.

For detailed instructor-led training, please contact us.