WallStreetMojo

WallStreetMojo

WallStreetMojo

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

Power BI Reports

Create Report on Power BI (Step by Step)

In power Bi reports are more visualized in compare to a common reports, in power bi reports it is a detailed visualization provided on a data, there are some connections need to be made in the data in order to make a report in power bi, reports can be multi-page level or it can be a single page and these pages have visuals.

If you are new to Power BI visualization and wondering what kind of impact Power BI could do to your data analysis, then in this article, we will show you how to prepare reports in Power BI data visualization.

Power BI Reports

To create 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 Reports Excel Template here – Power BI Reports Excel Template

Power BI Reports (Data)

This is the data of credit card transactions done in India. Using this data, we will create a dashboard to get insight into the data.

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
  • Step #1 – First thing first uploads the data to Power BI by using the “Get Data” option.

Power BI Reports (get data)

  • Step #2 – Now, you will see the window like the below one.

Power BI Reports (data preview)

  • Step #3 – Our data table name in the worksheet “Credit Card Transactions” is “CreditCard,” so I have chosen the required table to work with and now click on “Load” to upload the data to Power BI (it will take some time to upload).
  • Step #4 – In the “Data” layout, you should see the data table like the below one.

Power BI Reports (Data layout)

  • Step #5 – Once the data is uploaded, you need to come back to the “Report” layout to build your power bi reports and visualizations.

Power BI Reports (report layout)

  • Step #6 – First, we need to show what the total credit card usage amount is in the year by using the “Card” visual.

Power BI Reports ( card visual )

  • Step #7 – Now drag and drop the “Amount” column to “Fields.”

Power BI Reports (fields)

  • Step #8 – So, the overall transaction amount is “2 Billion”. We need to design the card for better visualization. The first thing we need to remove the category and add “Title” to the card.
  • Step #9 – The title can be added and formatted under the “Format” section of the Card visual. You need to format the “Title” of the card, as shown below.

Power BI Reports (Title format)

  • Step #10 – Now design the background of the card visual.

Background Formating

  • Step #11 – Now insert the border for the card.

Border Format

  • Step #12 – Now the number is showing in rounded billions, so instead of showing in rounded billings, let us add decimal places for billions.

data labels

  • Step #13 –Now copy the already designed Card to show a number of cities involved in this transaction.

Power BI Reports (no of cities)

  • Step #14 – For monthly spending of amount visualization, choose “Area Chart.” Add the “Date” column to Axis and retain only “Month” and add the “Amount” column to “Values.”

Power BI Reports (monthly spend of amount visual)

  • Step #15 – Just in case if you wish to add some formatting to the chart, you can add it under the “Format” section. I have formatted like the below one.

Power BI formatting

  • Step #16 – Now, to show various expenses type choose “TreeMap.”

Power BI Reports (Treemap)

  • Step #17 – We need to insert values to see the visual. Drag and drop “Exp Type” to “Group” and “Amount” column to “Values.”

Power BI Reports (drag and drop)

  • Step #18 – Just in case if you wish to add some formatting to the report, you can add it under the “Format” section. I have formatted like the below one. As of now, our report looks like this.

Treemap, Exp Type

  • Step #19 – The next visual we are going to use is the “Donut” chart to show transaction value done by different credit card categories.
  • Step #20 – Select the “Donut Chart” first, then drag and drop “Card Type” to “Legend” and “Amount” column to “Values.”

Power BI Reports (Donut Chart)

  • Step #21 – You can increase or decrease the inner circle of the donut chart under the “Shapes” formatting section.

Power BI shapes

  • Step #22 – Use “Matrix” visualization to show monthly-wise spent by different card types. In card types, we have four different categories, like “Silver, Signature, Gold, and Platinum.” So using Matrix, we can create a summary report.

Power BI Reports (matrix)
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 Reports Template here – Power BI Reports Template
  • Step #23 – Now, one more visualization we need to add is “Gender” wise spending share in the “Pie” chart. Select the Pie chart as visual and apply the fields accordingly.

Power BI Reports (Pie Chart)

  • Step #24 – To show who is using which card more Gender-wise, use “Line and Clustered Column Chart.”

line and Clustered Column Chart

So, our first page of the report is completed and looks like a beauty.

power bi final report

  • Step #25 – Now add one more page by click on the “Add Page” button.

Power BI Reports (New Page)

  • Step #26 – This will add a new Page to the right of the active page.

page 2

In this new page, we will show the City-wise transaction amount with the “Map” chart.

  • Step #27 – First, add the “Map” chart in Power BI.

Map Chart

  • Step #28 – Now choose “City” and “Amount” columns to see the bubbles.

Map Bubbles

So, our Power BI Report is ready to use.

Things to Remember

  • You can use any visual but make sure which fit for the data you are using.
  • Once the visual is used, you need to do formatting touches to make it look beautiful.
  • Always concentrate on how to fill in your page through the size of the visuals you are using.

Recommended Articles

This is a step by step guide to Power BI Reports. Here we discuss how to create custom reports in Microsoft Power BI along with an example and downloadable templates. You can learn more about Data Visualization from these articles below –

  • Power BI RANKX Function in Power
  • Excel for Power User Online Course
  • Dashboard Training in Excel
10 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

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 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 Excel Template

New Year Offer - Power BI Training Certification (22+ Hours of Training) View More