LOADING

Type to search

Interactive Dashboard In Microsoft Power BI

To Know more about the Different Corporate Training & Consulting Visit our website www.Instrovate.com Or Email : info@instrovate.com or WhatsApp / Call at +91 74289 52788

Data Analytics PowerBI

Interactive Dashboard In Microsoft Power BI

Share

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:’

Interactive Dashboard In Microsoft Power BI 29

Interactive Dashboard In Microsoft Power BI 30

 

Create 1st report:

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

Interactive Dashboard In Microsoft Power BI 31

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

Interactive Dashboard In Microsoft Power BI 32

Select Customer Id:

Interactive Dashboard In Microsoft Power BI 33

Select Line and Column visualization:

Interactive Dashboard In Microsoft Power BI 34

select stacked line

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

Interactive Dashboard In Microsoft Power BI 35

Interactive Dashboard In Microsoft Power BI 36

It is showing Quantity and Sales by Customer Id.

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

Interactive Dashboard In Microsoft Power BI 37

Select Pie Chart:

Interactive Dashboard In Microsoft Power BI 38

 

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

Interactive Dashboard In Microsoft Power BI 39

Interactive Dashboard In Microsoft Power BI 40

It displays Segment and count of Customer Id.

Select Consumer area:

Interactive Dashboard In Microsoft Power BI 41

Now let we create a tree map:

 

Interactive Dashboard In Microsoft Power BI 42

Select Ship mode and Customer Id:

Interactive Dashboard In Microsoft Power BI 43

 

Interactive Dashboard In Microsoft Power BI 44

 

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

Interactive Dashboard In Microsoft Power BI 45

Let do some formatting for Chart:

Interactive Dashboard In Microsoft Power BI 46

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

Interactive Dashboard In Microsoft Power BI 47

Create Country hierarchy:

Interactive Dashboard In Microsoft Power BI 48

Drag and drop State and City under Country hierarchy:

Interactive Dashboard In Microsoft Power BI 49

Interactive Dashboard In Microsoft Power BI 50

Select country hierarchy fields

Interactive Dashboard In Microsoft Power BI 51

Interactive Dashboard In Microsoft Power BI 52

Add Profit measure:

Interactive Dashboard In Microsoft Power BI 53

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

Interactive Dashboard In Microsoft Power BI 54

Let’s do some formatting:

Interactive Dashboard In Microsoft Power BI 55

Change result for Sales and Profit margin in percentage:

Interactive Dashboard In Microsoft Power BI 56

Interactive Dashboard In Microsoft Power BI 57

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

 

Copy all reports and paste and arrange in any order

Interactive Dashboard In Microsoft Power BI 58

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:

Interactive Dashboard In Microsoft Power BI 59

Now select only one state:

Interactive Dashboard In Microsoft Power BI 60

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.

Interactive Dashboard In Microsoft Power BI 61

Click on Publish:

Interactive Dashboard In Microsoft Power BI 62

Click on

Interactive Dashboard In Microsoft Power BI 63

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

Interactive Dashboard In Microsoft Power BI 64

Select Consumer from Pie chart:

Interactive Dashboard In Microsoft Power BI 65

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:

Interactive Dashboard In Microsoft Power BI 66

Click on dashboard icon:

Interactive Dashboard In Microsoft Power BI 67

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

 

Interactive Dashboard In Microsoft Power BI 68Here we can see our Dashboards.

Interactive Dashboard In Microsoft Power BI 69

These all are the Reports that we have already Published.

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

Interactive Dashboard In Microsoft Power BI 70

Extend My Workspace arrow:

Interactive Dashboard In Microsoft Power BI 71

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:

Interactive Dashboard In Microsoft Power BI 72

Interactive Dashboard In Microsoft Power BI 73

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:

Interactive Dashboard In Microsoft Power BI 74

Click on Pin

Go to My Workspace:

We can see our new dashboard is created:

Interactive Dashboard In Microsoft Power BI 75

Our new Dashboard is created.

Interactive Dashboard In Microsoft Power BI 76

Select all visualization and Pin to add on same dashboard.

 

Interactive Dashboard In Microsoft Power BI 77

Pin all the visualization for this Dashboard:

Interactive Dashboard In Microsoft Power BI 78

This is our Dashboard.

We can ask any question from here:

Interactive Dashboard In Microsoft Power BI 79

Ask one question:

Interactive Dashboard In Microsoft Power BI 80

We will get answer form Power BI.

Open menu for our Dashboard:

Interactive Dashboard In Microsoft Power BI 81

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.

 

Interactive Dashboard In Microsoft Power BI 82

 

Tags:

You Might also Like

Leave a Comment

Your email address will not be published. Required fields are marked *