WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Learn Power BI » Power BI Reports Examples

Power BI Reports Examples

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Let us not confuse power bi reports with power bi dashboards, reports are more of a detailed version of a dashboard, it has an extensive representation of data which we can see from the samples inbuilt or integrated into power bi itself for new users.

Examples of Power BI Reports

If you are new to Power BI and wondering how we can create reports in Power BI, then this article is the perfect fit for you. In this article, we will show you how to create examples of reports in Power BI with a simple technique to start off the learning in Power BI. You can download the workbook used in this example to practice along with us.

Power BI Reports Examples

You can download this Power BI Reports Examples Excel Template here – Power BI Reports Examples Excel Template

How to Create Reports in Power BI with Examples

Here we will show you how to create examples of reports in Power BI with a simple technique to start off the learning in Power BI.

#1 – Reports in Power BI

If you are already a reporting generator and advanced formula user in Excel, then creating reports in Power BI seems less difficult. So we assume that you are already an advanced excel user and starting this article.

Below is the data we are going to use to create a report in Power BI.

Power BI Report (Excel Data)

Please download the workbook to create a report along with us.

Popular Course in this category
Sale
Power BI Training Certification
4.5 (521 ratings)
6 Online Courses | 29+ Hours | Verifiable Certificate of Completion | Lifetime Access
View Course

Follow the below steps to upload the data to Power BI from the excel workbook.

Step 1: Open Power BI software.

Step 2: Go to the “Home” tab and find the “Get Data” option.

Power BI Report (Get data option)

Step 3: When you click on this “Get Data” drop-down list, we can see many data source options. Let’s not get into this as of now. Since our data source is in the form of an “Excel” workbook, let’s choose “Excel” only.

Power BI Report (Get Excel)

Step 4: Next, it will ask us to choose the file from the saved location, so choose the file from the folder where you have saved.

Power BI Report (Open Excel File)

Step 5: Next, click on “Open,” and it will take you to the navigator pane.

Power BI Report (Open navigator)

Step 6: From this navigator pane, we need to choose the table that we need to upload to the Power BI. So I will choose the “TV_Sales” table and click on “Load.”

Power BI Report (Choose TV_Sales)

Step 7: Now, you can see your screen will flicker for some seconds, and finally, it will upload to Power BI. By clicking on the “Data” tab, you can see the uploaded data.

Power BI Report (uploaded data)

Ok, we are done with the data upload steps, now we need to create some additional columns.

#2 – Create Calculated Columns

If you see the table, we don’t have full data like “Sale Value, Gross Profit, and Gross Profit %” etc.… We need to create these columns by using DAX formulas.

  • Now come to the “Report” tab.

Power BI Report (Choose Report Tab)

  • On the right-hand side, we can see all the fields of the table.

Power BI Report (Show all Fields)

  • Right-click on the table name “TV_Sales” and choose “New Column.”

Power BI Report (Choose New Column)

  • This will ask you to name the column name in the formula tab, so give the name as “Sale Value.”

Power BI Report (Open formula tab)

  • By entering what formula we need to arrive at the “Sale Value”????
  • To arrive at the “Sale Value” from the existing columns of the table, we need to multiply “Units Sold” into “Sale Price.”
  • Type the characters as “Units,” and you will see all the related results. Choose the “Units Sold” column from the “TV_Sales” table.

Power BI Report (Choose Units Sold)

  • Now enter the “Multiply” sign (*) and choose the “Sale Price” column.

Power BI Report (Choose Sale Price)

  • Hit the enter key, and in the table, the new “Calculated Column” is created.

Power BI Report (Add Sale Value)

  • Now once again, right click and choose “New Column” to create the “Gross Profit” value. This time we need to enter the formula as “Sales Value – COGS – Discount.”

Power BI Report (Gross Profit)

Ok, now we are done with calculations. To start off things in Power BI, this is more than enough.

#3 – Create Reports in Power BI (By Using Fields)

  • Ok, by using these fields, we will create reports.
  • On the right-hand side, we have several visualizations. From this list, click on “Table” visual to insert the blank table visually.

Create Reports in Power BI

  • This table works more or less like “Pivot Table” in our excel worksheet. Now drag and drop “Month Name” from the table to the “Values” field of Table visual.

Power BI Report (Month Name)

  • Now drag and drop “Sale Value,” “COGS,” “Discount,” and “Gross Profit” columns to the field area of Table visual.

Table Visual

  • Ok, we have a month-wise summary table of Sales, COGS, Discount, and Gross Profit.
  • For the same fields, we will insert the “Combo” chart to see the “Sales vs Gross Profit.” Click on “Combo Chart” from the visuals list.

Create Combo Chart

  • For the fields of this “Combo Chart,” drag and drop columns as shown below.

Drag and drop

  • This will create a chart like the below one.3

Combo Chart

  • This chart will explain “Gross Profit” positons against the “Sale Value.” Similarly, we will create a combo chart of “Gross Profit vs Combo Chart.”

Gross Profit vs Combo Chart

  • Now we will create the “Funnel” chart to create a City-wise “Sale Value.” Click on “Funnel Chart” to create a blank “Funnel Chart.”

Create Funnel Chart

  • Drag and drop the “City” column to the “Group” field and “Sale Value” to the “Values” field, and we will have a “Funnel Chart” like the below one.

Funnel Chart

  • In the end, we will create “Card” visuals to show total sales, COGS, Discount, and Profit values. Click on “Card” visual to insert “Blank Card Visual.”

Blank Card Visual

  • Drag and drop the “Sale Value” column to “Fields,” and we will have a simple card that shows the overall sales value.

shows overall sales value

  • Now copy and paste this “Card” visual three more times.

Show all Cards

  • Now for the second card, change the field from Sale Value to “COGS,” for the third one, change it to “Discount,” and for the fourth one, change it to “Gross Profit.”

Again show all cards

  • Ok, overall, we have a simple power bi dashboard like the below one.

Create Simple Dashboard

Note: Power BI dashboard file can also be downloaded from the link below, and the final output can be viewed.

You can download this Power BI Reports Examples Template here – Power BI Reports Examples Template

Things to Remember

  • If the required column is not there in the data, then we need to create the one by using DAX formulas.
  • The kind of visual we use for the particular set of data makes a lot of difference in the dashboard.

Recommended Articles

Guide to Power BI Reports Examples. Here we show you how to create reports in Power BI along with examples and step by step explanations. You may learn more about Power BI from the following articles

  • Calendar in Power BI
  • Power BI Date Formatting
  • Power BI Drillthrough
  • Power Query Excel
13 Shares
Share
Tweet
Share
Power BI Training Certification
  • 6 Online Courses
  • 29+ Hours
  • Verifiable Certificate of Completion
  • Lifetime Access
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Download Power BI Reports Examples Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

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

Login

Forgot Password?

WallStreetMojo

Download Power BI Reports Examples Excel Template

Coursera IPO Financial Model & Valuation Free Download