If you are looking for a Microsoft Power BI Corporate Training in Gurgaon , please feel free to reach out at info@instrovate.com or whatsapp at +91-9953805788 

 

 

In my previous blogs we have gone through few visualizations and created Reports in Power BI. Today’s I will explain how to create dashboard from different reports.

Load data in Power BI:’

 

Create 1st report:

Select Customer Id and Order Id and click on bar chart visualization:

Change page name to Bar Chart and go to page 2:

Select Customer Id:

Select Line and Column visualization:

select stacked line

Drag Sales for Line Value and drag Quantity for Column Value field:

It is showing Quantity and Sales by Customer Id.

Save this report and click on next page > now we will create a Pie Chart:

Select Pie Chart:

 

Select Segment for Legend field and Customer Id and drop in Value field:

It displays Segment and count of Customer Id.

Select Consumer area:

Now let we create a tree map:

 

Select Ship mode and Customer Id:

 

 

Now let’s create a report for Sales and Profit by Customer Id:

Let do some formatting for Chart:

Go to new page> Now we will create a map:

Create Country hierarchy:

Drag and drop State and City under Country hierarchy:

Select country hierarchy fields

Add Profit measure:

Drag Profit margin in color saturation and Sales field in Size field:

Let’s do some formatting:

Change result for Sales and Profit margin in percentage:

Now we will combine all reports on one page to make an interactive dashboard:

 

Copy all reports and paste and arrange in any order

I have added a card for Count of customer id.

Now our one interactive report is ready, here we can see results interactively.

For example, select Consumer segment and it will display all result for that particular segment only:

Now select only one state:

Here results are for that states only for all charts.

Now our last step is to publish our Report to Power BI site so that we can share our report to others.

Click on Publish:

Click on

It will give us a path where our Report got Published. Click on that path. It will redirect us on Power BI site:

Select Consumer from Pie chart:

Here we can see that we have publish a report with all interactivity on web too.

Go to Recent tab:

We can see we have few Report icon and few dashboard icons under Name column:

Click on dashboard icon:

Click on Work Space > here we have different place for Dashboard, Reports, workbooks and datasets

 

Here we can see our Dashboards.

These all are the Reports that we have already Published.

Few actions are present for reports and dashboard items as well.

Extend My Workspace arrow:

Here we can see all items under my workbook sections. (Dashboard, Reports, Dataset)

Now we will create a Dashboard from Reports as reports cannot be share with others, and in order to share reports we need to create Dashboard. Dashboard is a collection of various visualization elements from report.

Pin is a way of adding report elements in to dashboard item.

Go to Reports part> click on Pin visuals:

Here we have option to add element in existing dashboard or we can create a new one. Let’s we will create a new one:

Click on Pin

Go to My Workspace:

We can see our new dashboard is created:

Our new Dashboard is created.

Select all visualization and Pin to add on same dashboard.

 

Pin all the visualization for this Dashboard:

This is our Dashboard.

We can ask any question from here:

Ask one question:

We will get answer form Power BI.

Open menu for our Dashboard:

We can share Dashboard to anyone who have an account on Power BI.

This was all about creating Power BI Report and Publish on Power BI site, Create a new Dashboard and Share dashboard with others.