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.

The Treemap is very useful for displaying the largest data in a small region. For this Create a Power BI Treemap demonstration, we will use the SQL Data Source we created in our previous article.

How to Create a Power BI Treemap?

To create a Power BI tree map, first, drag and drop the Sales Amount from the Fields section to Canvas. Then, it automatically creates a Column Chart. Please refer to Connect to SQL Server article to understand the Power BI Data Source.

Column Chart 1

By clicking the Treemap under the Visualization section, automatically convert the Column Chart into Treemap.

Select the Visualization 2

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

Create Power BI Treemap 3

Create a Treemap Approach 2

When you click on the Treemap present in the Visualization section, it creates a chart with dummy data.

Create Power BI Treemap 4

To add data to Power BI TreeMap, we have to add the 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 the Fields section to the Values field.

Drag Fields to Values 5

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

Add measure Field to Groups 6

Now you can see the TreeMap of Sales Amount divided by Employees Department Name. Hover over any box that shows 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 refer to the Formatting 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

Treemap FAQs

How do I add a tree map in Power BI?

How do I add a tree map in Power BI?
Click on the Treemap icon under Visualization will automatically generate. In addition, add Sales (Measure) to the Values section and a dimension (stages) to Category. There is an option to add another dimension to the details to divide the rectangles further.

What is a Power BI treemap used for?

Treemaps use rectangular boxes with different colors to represent the hierarchal data. Each row represents a rectangle, and the measure value defines its size. The bigger the size, the more sales, and the smaller the size, has fewer sales.

Is Treemap a good Visualization?

If you have hierarchal data with different nested levels, then Treemap is the ideal chart to represent that data.

Can Power BI TreeMap have multiple values?

Yes. Place the dimension field on the Details section will further divide each rectangle based on the details section value.

Is a TreeMap automatically sorted?

Yes. The rectangle boxes are sorted based on the Measure (Sales) value where the largest is top left and the smallest is bottom right.