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.
By clicking the Treemap under the Visualization section, automatically convert the Column Chart into Treemap.
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 a Treemap Approach 2
When you click on the Treemap present in the Visualization section, it creates a chart with dummy data.
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.
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.
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.
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.
Treemap FAQs
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.
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.
If you have hierarchal data with different nested levels, then Treemap is the ideal chart to represent that data.
Yes. Place the dimension field on the Details section will further divide each rectangle based on the details section value.
Yes. The rectangle boxes are sorted based on the Measure (Sales) value where the largest is top left and the smallest is bottom right.
