Create Power BI Treemap

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. In this article we will show you, How to Create a Treemap in Power BI with example.

Tree maps in Power BI are very useful to display largest data in small region. 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

First, Drag and Drop the Sales Amount from Fields section to Canvas. This will automatically create a Column Chart as shown in below screenshot.

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

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 a Power BI Treemap – Approach 2

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

In order to add data to Tree map, 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 Amount from Fields section to Values field.

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

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

Let me do some quick formatting to the Tree map

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

Thank You for Visiting Our Blog