Tutorial Gateway

Create Power BI Treemap

by

Power BI Treemap is used to display the data in Rectangle Boxes. You can define the rectangle box using any Dimension column, and its size by Measure value.

The Tree maps in Power BI are very useful to display largest data in small region. In this article we will show you, How to Create a Treemap in Power BI with example.

For this demonstration we are going to use the SQL Data Source that we created in our previous article. So, Please refer Connect Power BI to SQL Server article to understand the Data Source.

How to Create a Power BI Treemap

In order to create a Power BI tree map, first, Drag and Drop the Sales Amount from Fields section to Canvas. This will automatically create a Column Chart as shown in below screenshot.

Create Power BI Treemap 1

By clicking the Treemap under the Visualization section will automatically convert the Column Chart into Tree map

Create Power BI Treemap 2

Next, let me add the English Product Name from DimProduct Table to Group section. This will divide the rectangle boxes based on the Sales amount by each product.

Create Power BI Treemap 3

Create a Power BI Treemap Approach 2

When you click on the Treemap present in the Visualization section will automatically create a Tree map with dummy data as shown in below screenshot.

Create Power BI Treemap 4

In order to add data to Power BI TreeMap, we have to add required fields:

  • Group: Please specify the Column that divides the Rectangle Boxes.
  • Values: Any Numeric value such as sales amount, Total Sales, Customer count etc.

Let me drag and drop the Sales from Fields section to Values field.

Create Power BI Treemap 5

Next, add Department Name from DimEmployee table to the group section. You can do this by dragging Department Name to Group section, or simply check mark the Department Name column

Create Power BI Treemap 6

Now you can see the Tree Map of Sales Amount that is divided by Employees Department Name. Hover over any box will show you the Tool-tip of Department Name and its Sales Amount

Create Power BI Treemap 7

Let me do some quick formatting to the Power BI Tree map

NOTE: I suggest you to refer Format Tree Map article to understand the steps involved in formatting the Power BI TreeMap Box Colors, Title font, Title alignment, Data labels and colors.

Create Power BI Treemap 9

Thank You for Visiting Our Blog