Examples of Power BI Reports

If you are new to Power BI and wondering how we can create reports in Power BICreate Reports In Power BIPower bi reports are detailed visualizations of data that are presented differently than common reports. These reports can be multi-page or single-page, with visuals on each page.read more, then this article is the perfect fit for you. This article will show you how to create examples of reports in Power BI with a simple technique to start learning. You can download the workbook used in this example to practice with us.

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Power BI Reports Examples (wallstreetmojo.com)

How to Create Reports in Power BI with Examples

Here, we will show you how to create examples of reports in Power BI with a simple technique to start learning in Power BILearning In Power BIPower BI is a business intelligence tool that helps convert raw data into meaningful insights through dashboards, reports, and applications (apps). It helps visualize data from a variety of visual elements available. read more.

#1 – Reports in Power BI

If you are already an Excel reporting generator and advanced formula user in ExcelAdvanced Formula User In ExcelVLOOKUP, INDEX, MATCH, and IF AND are just a few of the advanced Excel formulae and functions available in Excel.read more, creating reports in Power BI seems less difficult. So, we assume you are already an advanced Excel user and starting this article.

Below is the data we will use to create a report in Power BI.

Please download the workbook to create a report along with us.

We are done with the data upload steps. Now, we need to create some additional columns.

#2 – Create Calculated Columns

If you see the table, we do not have robust data like “Sale Value,” “Gross Profit,” “Gross Profit %,” etc. Therefore, we need to create these columns by using DAX formulas.

  • Now come to the “Report” tab.

  • On the right-hand side, we can see the table’s fields.

  • Right-click on the table name “TV_Sales” and choose “New column.”

  • It will ask you to name the column name in the formula tab, so give the name as “Sale Value.”

  • Now, enter the “Multiply” sign (*) and choose the “Sale Price” column.

  • Press the “Enter” key. The new “Calculated Column” is created in the table.

  • Now, right-click and choose “New column” to create the “Gross Profit” value. This time we need to enter the formula: Sales Value – COGS – Discount.

Now, we are done with calculations. But, this is more than enough to start things in Power BI.

  • This table works more or less like the “PivotTable” in our Excel worksheet. Now, drag and drop “Month Name” from the table to the “Values” field of the “Table” visual.

  • Now, drag and drop the “Sale Value,” “COGS,” “Discount,” and “Gross Profit” columns to the “Fields” area of the “Table” visual.

  • We have a month-wise summary table of “Sales,” “COGS,” “Discount,” and “Gross Profit.”We will insert the “Combo” chart for the same fields to see the “Sales vs. Gross Profit.” Click on “Combo Chart” from the visuals list.

  • For the fields of this “Combo Chart,” drag and drop columns as shown below.

  • It will create a chart like the one below.

  • This chart will explain the “Gross Profit” positions against the “Sale Value.” Similarly, we will create a combo chartCombo ChartExcel Combo Charts combine different chart types to display different or the same set of data that is related to each other. Instead of the typical one Y-Axis, the Excel Combo Chart has two.read more of “Gross Profit vs. Combo Chart.”

  • We will create the “Funnel” chart to create a City-wise “Sale Value.” Click on the “Funnel” chart to create a blank “Funnel” chart.

  • Drag and drop the “City” column to the “Group” field and “Sale Value” to the “Values” field. We will have a “Funnel” chart like the one below.

  • Ultimately, we will create “Card” visuals to show “Total Sales,” “COGS,” “Discount,” and “Profit” values. Click on the “Card” visual to insert a blank “Card” visual.

  • Drag and drop the “Sale Value” column to “Fields.” We will have a simple card showing the overall sales value.

  • Now, copy and paste this “Card” visual three more times.

  • Now, for the second card, change the field from “Sale Value” to “COGS.” For the third, change it to “Discounts.” Finally, for the fourth, change it to “Gross Profit.”

  • Overall, we have a simple power bi dashboard like the below one.

Note: We can also download the Power BI dashboard file from the link below. We can view the final output.

Things to Remember

  • If the required column is not in the data, we must create the one using DAX formulas.The visual we use for the particular data set makes a lot of difference in the dashboard.

This article is a guide to Power BI Reports Examples. Here, we show you how to create Power BI reports with examples and step-by-step explanations. You may learn more about Power BI from the following articles: –

  • Calendar in Power BIPower BI Date FormattingPower BI DrillthroughPower Query Excel