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 Dashboard Examples

Power BI Dashboard Examples

Power Bi dashboards are a single-paged dashboard that summarizes the data briefly, there are various inbuilt samples of dashboards in power bi which a new user can access and use it as per the requirements however the hone or the expert users create own dashboards for better representations.

Dashboard in Power BI Examples

The power BI dashboard is simply amazing to work with. Dashboards can tell the story of the large data set in a single page itself. So, by creating dashboards, we try to convey the message to the end-user as briefly as possible with as much information as possible. Creating a dashboard is fun if you know the tool to create your dashboard, or else we just need to wonder about how others have created their dashboard, which just rocks in a single page view. All these while you might have created dashboards using excel, but now the trend of modern business is visualization tools i.e., Power BI. In this article, we will show you how to create dashboards using the Power BI tool with examples.

To create examples of a dashboard in Power BI, you need data to work with, so you can download the excel workbook template from the below link, which is used for this example.

Examples of Power BI Dashboard

You can download this Examples of Power BI Dashboard Excel Template here – Examples of Power BI Dashboard Excel Template

How to Create a Dashboard in Power BI (Step by Step Examples)

Below is how to use the Power BI tool to create a dashboard example.

Below is the data we are using to build a dashboard. This is the TV sales data in Indian cities in month-wise.

Power BI Dashboard Example (Excel Data)

Using these numbers, we will build a beautiful dashboard. Follow the below steps to build the dashboard; you can download the data from the below link to practice along with us.

Step 1: Open Power BI software, go to HOME tab >>> Get Data > Excel.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Power BI Dashboard Example (Open Excel)

Step 2: From the file chooser window, choose the file from the computer location where you have stored.

Step 3: From the below window, you need the required table to be uploaded to Power BI.

Power BI Dashboard Example (Show two options)

Choose the table and click on “Load” to upload the selected table to Power BI.

Power BI Dashboard Example (Load data)

Step 4: Now, our data is uploaded to Power Bi, and under the data section, we should see the uploaded data table.

Power BI Dashboard Example (Data)

Step 5: Now come back to the “Report.”

Power BI Dashboard Example (Go to report)

Step 6: Here, we need to rearrange our data to create a dashboard. First, we need to find what the sales value is by using DAX formulas. Click on “New Column” under “Modelling.”

Power BI Dashboard Example (Open new column)

Step 7: Now, in the New column, first give the name for the column as “Sale Value.”

Power BI Dashboard Example (sale value)

Step 8: Sale Value is calculated by using this formula “Units Sold * Sale Price.” Type these header names to see the IntelliSense list.

Power BI Dashboard Example (Select unit sold)

You need the first type the table name then followed by a column header name. After selecting the Units Sold column, multiply it with “Sale Price.”

Power BI Dashboard Example (Formula)

Step 9: After applying the formula, hit the enter key, and we should have a new column named “Sale Value” in the table fields.

Power BI Dashboard Example (Fields)

Step 10: Similarly, you need to create one more new column for “Gross Profit,” as shown below.

Power BI Dashboard Example (Gross Profit)

Step 11: Insert one more column and put the below DAX formula to find the Gross Profit percentage.

Power BI Dashboard Example (Gp %)

Now we are done with all the calculated columns. Let’s create visuals for these fields.

  • Create a Card Visual for Sale Value, COGS, and Gross Profit. Insert card first.

Power BI Dashboard Example (Select card)

  • Now drag and drop the “sale value” column to “Fields.”

Power BI Dashboard Example (Drag and drop)

  • It should give us total sales value in the card.

Power BI Dashboard Example (Sale value card)

  • As you can see above by default card visual, apply the number formatting, and the total sale value says “99.37 M”. We can change the formatting of this card under the formatting section.

Power BI Dashboard Example (Open format)

  • We have a various variety of options; you can make use of all these to format your visual. I have formatted the card, as shown below.

Power BI Dashboard Example (Formatting card)

I have removed “Category Label,” inserted “Title” and formatted the title, “Background” color has been changed, and the “Data Label” color has been changed.

  • Now to show COGS and Profit Value, copy and paste the same visual two more times and change the fields accordingly.

Show COGS $ Profit Value

  • Now to monthly Sales, COGS, and Gross Profit choose the “Matrix” table.

Power BI Dashboard Example (Select matrix)

  • Drag and drop “Month Number” to row field, “Sale Value,” “COGS,” and “Gross Profit” columns to the “Values” field.

Drag and drop

  • Now we have a “Matrix” table like the below one.

Create matrix table

  • Now create one more Matrix table to show monthly gross profit numbers at different discount bands.
  • Drag and drop “Month Number” to row field, “Gross Profit” columns to the “Value” field, and for “Column Field” insert “Discount Band.”

Drag and drop 1

  • Now we have two different matrix tables showing data numbers.

Two different matrix table

From this table, we can conclude that when the discount was high gross profit amount was 6574110, but when the discount was not there gross profit amount has been reduced to 1379212.

  • Now insert the “Donut” chart to show the “Product-wise” sales amount.

Create donut chart

  • Now insert “Treemap” to show city-wise sales, cogs, and profit values.

Drag and drop 2

  • This will create a treemap like the below one.

Create tree map

  • Now insert one more new page.

Insert new page

  • On this page, choose “Map” visual.

Choose map

  • For this Map, visual, insert the “City” column for “Location” and “Sale Value” for “Size.”

Drag and drop 3

  • This will create bubbles for each city based on sales amount numbers.

Create bubbles

  • Increase the map size by dragging the ends of the map.

Create Map

These bubbles show the sales value in each city.

Note: To apply DAX Formulas, we need data; you can download the Power BI file to get the ready table.

You can download this Examples of Power BI Dashboard Template here – Examples of Power BI Dashboard Template

Things to Remember

  • If data doesn’t have all the columns to create a dashboard, then you need to create those columns by adding calculated columns.
  • Do not leave the page empty and, based on the visual count, increase or decrease visual size.
  • To show a map, a visual city or country name should be properly entered.
  • Each visual has its own formatting, so you need to apply custom formatting to make it look beautiful.

Recommended Articles

This has been a Guide to Examples of Power BI Dashboard. Here we discuss examples of how to create a Power BI dashboard examples using DAX formulas to count all unique values and create charts. You can learn more about Power BI from the following articles –

  • Power BI Dashboard vs Report
  • Visuals in Power BI
  • Icons in Power BI
  • KPI in Power BI
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
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 Examples of Power BI Dashboard 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 Examples of Power BI Dashboard Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More