EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Data Science Data Science Tutorials Power BI learn Power BI Report
 

Power BI Report

Priya Pedamkar
Article byPriya Pedamkar

Power BI Report

Report in Power BI

Reports are those elements of any BI and analytics tool that renders the very analytics characteristic to the tool. Power BI offers a convenient and effective methodology to build reports which can be used to drive excellent data analysis. The various functionalities provided by Power BI makes it one of the most favorite BI tools. Reports enable the stakeholders to dig deeper into data to reach the insights which help them in decision making.

 

 

Creating Analysis Report in Power BI

We will now go through a step-by-step procedure to create a report in Power BI. For this demonstration, we are going to use the “Product Region Sales” dataset. The dataset contains sales and profit percentages for various products given region wise. Product and Region are dimensions, while Sales and “Profit in %” are measures present in the dataset. Let’s proceed.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

To create Power BI Reports you need data to work with, so you can download the excel workbook from the below link which is used for this example.

You can download this Power BI Report Excel Template.xlsx here – Power BI Report Excel Template.xlsx

Step 1: Now to create Parameters in Power BI, first we need to upload this data in Power BI. For loading the requisite data, click on Get Data drop-down menu in the Home tab. From the drop-down menu select the requisite data source type. In this case, it is “Excel”, so we clicked on it.

Example 1 (Menu Ribbon)

Step 2: Now, select the file containing requisite data as shown below.

Power BI Report Example 2

Step 3: Selecting the file, navigates us to the Navigator pane. From the pane, select the requisite sheet. In this case, it is Sales. Finally, click on the Load button to load the data into Power BI.

Example 3 (Navigator)

Step 4: When the data gets loaded, the requisite dimensions and measures can be seen in the Fields section as highlighted in the following screenshot.

Example 4 (Fields section)

Step 5: To begin with the creation of a report, click on the Pie Chart symbol in the Visualizations section. When we click on the Pie chart symbol, the Pie chart layout gets created as shown by the following screenshot. With Pie chart analysis we intend to understand each region’s contribution to total sales. Power BI offers us insight into contribution in terms of both, total as well as percentage.

Example 5 (Pie Chart)

Step 6: Now, in the Fields section, drag Region dimension in legend field and “Sales in Million” into value field measure. This will create a pie chart for the region with insight into sales contribution.

Power BI Report Example 6

Step 7: The pie chart that gets created can be seen as shown by the following screenshot.

Note, the screenshot is the zoomed view of the visualization which can be obtained by clicking on “Actual View” option (View -> Page View -> Actual Size).

Example 7 (Actual View)

Step 8: Next, we will create a clustered column chart. This chart shall enable us to analyze the performance of various product types by region. In order to bring it into analysis, click on “Clustered column chart” option in Visualizations.

Example 8 (Clustered Column Chart)

Step 9: In the Fields section, select the first Region dimension, then “Sales in Million” measure and finally, Product dimension, in this order. Selecting the fields in proper order will give us the clustered column chart as shown by the screenshot subsequent to the below one.

Power BI Report Example 9

Step 10: Click on “Card” visualization.

Power BI Report Example 10

Step 11: Working with card visualization is quite simple. Just click on the measure which we want to be brought into the analysis. In this case, we are interested in the “Sales in Million” measure, so we checked it in the Fields section.

Example 11 (Fields section)

Step 12: The following screenshot shows the “Sales in Million” measure in the analysis. It must be noted that the aggregate function applied over the measure plays a significant role. In this case, it is Sum, and we got total sales. We can have Average also, however, in this case, we are more interested in analyzing the overall total sale and the corresponding average profit percentage.

Power BI Report Example 12

Step 13: We will also bring an average “Profit in %” measure into the analysis by following the above procedure. By default the aggregate function over the measure is Sum. In order to change it to Average, go to the drop-down menu of the corresponding measure in the Fields section, and click on Average.

Power BI Report Example 13

Step 14: Automatically, in the Card, the display text gets changed to “Average of Profit in %”.

Power BI Report Example 14

Step 15: Till now, we are done with three analyses. The fourth analysis that we would like to bring into the analysis is the “Multi-row card”. This analysis type can be considered similar to a table that offers us insight into data through figures. We will create this analysis for various products in order to under the total sales and average profit percentages by the Product dimension. By driving the product-wise analysis, we will complete the analysis for the Sales dataset.

Power BI Report Example 15

Step 16: Next, in the Fields section, select the Product dimension and both “Profit in %” and “Sales in Million” measures as highlighted in the below screenshot.

Power BI Report Example 16

Step 17: Following the above procedure gives us the Multi-row card with requisite details as shown by the following screenshot.

Power BI Report Example 17

Step 18: Note, in the above step, we changed the aggregate function for the “Profit in %” measure by following the requisite steps mentioned in the preceding section. When we are finally done with the analysis, we should properly examine the report. So, let’s have a glimpse of the report that we successfully created using the above steps. This is as shown by the following screenshot.

Power BI Report Example 18

Note: I have done so much of formatting to this table, you can download the Power BI dashboard file from below link and apply each formatting technique as applied.

You can download this Power BI Report Template.pbit here – Power BI Report Template.pbit

Things to Remember

  • A report should be created in Power BI only after proper planning and studying the dataset and its elements i.e. dimensions and measures.
  • Various types of visualizations are provided by Power BI, each of which has a specific purpose. So, the selection of visualization should be based on the context and it should best serve the purpose of insight generation.

Recommended Articles

This is a guide to Power BI Report. Here we discuss how to create a Report in Power BI for Analysis along with an example and downloadable template. You may also look at the following articles to learn more –

  1. How to Create Charts in Power BI?
  2. How to Design Pie Chart in Power BI?
  3. Top 6 Power BI Connections
  4. Learn the Power BI Alternatives

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Power BI Report Excel Template.xlsx

EDUCBA Login

Forgot Password?

EDUCBA

Download Power BI Report Excel Template.xlsx

🚀 Limited Time Offer! - 🎁 ENROLL NOW