Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Create a Dashboard in Power BI

Power BI Dashboard Sample.png

Create a Dashboard in Power BI

Dashboards can tell the story in a single page view and it’s an interactive tool as well. So Power BI is best suited to create such kind of interactive dashboards. So in this article, we will show you how to create an interactive sample sales Dashboard in power bi.

Below is the data we are using to build a dashboard. This is the dummy data of various mobile phones sold in different cities of India. You can download the excel workbook to create a dashboard in Power BI.

You can download this Power BI Dashboard Sample Excel Template here – Power BI Dashboard Sample Excel Template

Power BI Dashboard Sample (Data)

How to Create a Sample Sales Dashboard in Power BI?

Follow the below steps to create a sample sales dashboard in power bi.

Upload Data to Power BI

  • Step 1: Open Power BI File and go to the Home tab and click on Get Data and choose the data source as “Excel”.

Power BI Dashboard Sample (Get Data)

  • Step 2: Choose the file from the saved location and click on “Open”.

Power BI Dashboard Sample (Excel open)

  • Step 3: Before you upload the file it will ask you to choose the data table, so choose the table name (My table name is “Mobile_Sales”) and click on “Load” to upload the selected table data to Power BI.

Power BI Dashboard Sample (Load)

It will take some time to upload.

Now we can see the data in the “Data” view.

Power BI Dashboard Sample (Data Tab)

Create New Calculated Column

  • From the data table we have only “Units Sold” and “Price Per Unit” only, so we need to calculate “Total Sales”. Right-click on the table name and choose “New Column”.

Power BI Dashboard Sample (New Column)

  • This will ask you to name the column first, so give a name as “Total Sales”.

Power BI Dashboard Sample (Total Sales)

  • This column will be calculated by multiplying Units with Sale Price, so from the table choose “Units Sold and Sale Price” columns.

Power BI Dashboard Sample (Total Sales Formula)

This will create a new column in the Table as “Total Sales”.

Power BI Dashboard Sample (Total Sales column)

  • We need to format this column as “Currency”, so select the column go to “Modelling” and choose the format as “Rupee”.

Power BI Dashboard Sample (Curreny- Rupees)

  • Come back to the “Report” view now.

Power BI Dashboard Sample (Report)

In this report view, we will create a dashboard now.

  • First, insert the title bar for the dashboard. Go to the HOME tab click on Shapes and choose the “Rectangle” shape.

Power BI Dashboard Sample (Shapes).png

  • Draw this shape at the top of the page.

Power BI Dashboard Sample (Rectangle)

  • Change the background color of this shape, select the shape and it will open up the “Format Shape” option to the right side.

Power BI Dashboard Sample (Format Shape)

  • Click on “Fill” >>> Fill Color >>> Custom Color.

Power BI Dashboard Sample (Custom Color)

  • Power BI works on HEXA color codes, so we can get the color codes from the “color-hex.com” website. So you can choose the color code (without #) as you wish to have and paste it.

Power BI Dashboard Sample (color code)

  • Now our shape filled with blue color.

Power BI Dashboard Sample (filled with blue color)

  • Now from home tab insert Text Box.

Power BI Dashboard Sample (Text Box).png

  • Type the text as “Sales Dashboard”.

Power BI Dashboard Sample (Sales Text)

  • Place this on the shape, change the font color to white.

Power BI Dashboard Sample (Sales Dashboard)

  • Now we need to create Slicer visuals. From the visualization, tab inserts blank Slicer and Date column from the table to the Field of Slicer.

Power BI Dashboard Sample (insert Slicer)

Power BI Dashboard Sample (Slicer)

  • Now we need to design this slicer, so choose the slicer and click on the “Format” option. Choose “Data Inputs” and apply the below changes.

Power BI Dashboard Sample (Formatting)

  • Now our start and end dates are formatted like the below.

Power BI Dashboard Sample (Dates)

  • Now change the background color.

Background

Like this, you can change the border and other things. Now our “Date” slicer looks like this.

Slicer 1

Like this, we need to create four more slicers to have “City, Product, Manager, and Month” columns. Copy and paste the same slice but change the field column and header of the slicer respectively. I have created similar slicers and below is the image of the same.

Slicers

  • Now let’s insert “Card Visual” to show “Total Sales” value.

Card Visuals

Card Visuals shows the total sales value.

Total sales Card

  • Now Design the card through the formatting section and it looks like this.

Card Format

  • Like this creates two more for total units sold and COGS.

Units Sold & COGS

  • Insert the “Doughnut” chart to show “City-wise” Sales value.

Donut Chart

  • Insert “TreeMap” to show Manger-wise sales value.

TreeMap

One final visual we are going to add is the “Date-wise” sales value.

Area Chart

So, finally, our Sales dashboard in power BI looks like this.

Power BI Dashboard Sample (Sales Dashboard Image).png

Like this, by using Power BI we can create interactive dashboards.

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

You can download this Power BI Dashboard Sample Template here – Power BI Dashboard Sample Template

Things to Remember Here

  • If the required column is not there in the data then we need to create by using DAX function.
  • To get attractive colors to search on the web about Hexa Color codes.
  • Always maintain the dashboard with the most important data.

Recommended Articles

This has been a guide to Power BI Dashboard. Here we discuss how to create a sample interactive dashboard in Power BI along with an example. You can learn more about Power BI from the following articles –

  • Excel Dashboard Training Course
  • Create Waterfall Chart in Power BI
  • Create Gantt Chart in Power BI
  • Basic Tutorial in Power BI

The post Create a Dashboard in Power BI appeared first on Wallstreet Mojo.



This post first appeared on Free Investment Banking Tutorials |WallStreetMojo, please read the originial post: here

Share the post

Create a Dashboard in Power BI

×

Subscribe to Free Investment Banking Tutorials |wallstreetmojo

Get updates delivered right to your inbox!

Thank you for your subscription

×