Power bi treemap – How to use

In this power bi tutorial, we will learn power bi treemap. And also we will discuss the below points:

• Power bi treemap
• When to use power bi treemap
• Power bi treemap visual
• Power bi treemap vs pie chart
• Power bi treemap multiple values
• Power bi treemap top 10
• Power bi treemap drill down
• Power bi treemap multiple levels
• Power bi treemap show value and percentage
• Power bi treemap percentage
• Power bi treemap conditional formatting
• Power bi treemap details
• Power bi treemap change order

What is Power bi treemap?

• Power bi treemap display hierarchical data as a set of nested rectangle.
• In power bi treemap each level of the hierarchy is represented by color rectangle known as branch, containing smaller rectangle known as leaves.
• In treemap power bi bases the size of the space inside each rectangle on the measured value.
• The rectangle in treemap are arranged in size from top left (largest) to bottom right (smallest).

When to use power bi treemap

Here we will see when to use power bi treemap.

The power bi treemap is a perfect choice:

• When to display large amount of hierarchichal data.
• When bar chart cannot handle the large number of values.
• When to show the pattern of the distribution of the measure across each level of categories in the hierarchy.
• When to show the proportion of each part and whole.
• When to attributes using color coding and size.
• When to spot patterns, most important contributers, outliers and exceptions.

Read Power BI average function with Examples

Create Power bi treemap visual

Here we will see how to create a power bi treemap visual in power bi desktop using sample data.

• Open your power bi desktop and Load the data using get data
• Select the treemap from the visualization pane.
• In the Group field, drag and drop the Sub-category from the field pane.
• In the Details field, drag and drop the category from the field pane.
• In the Value field, drag and drop the Profit from the field pane.

In the below screenshot, you can see the power bi treemap visuals.

Read How to use Power bi ribbon chart

Power bi treemap vs pie chart

Here we will see power bi treemap vs pie chart in power bi desktop.

Treemap	Pie chart
Power bi treemap represented as rectangular	Power bi pie chart represented as circular
Each measure is represented as rectangular in the treemap	In the pie chart the circular is divided into a wedge, the larger the wedge the bigger is the measure.
Like the wedges in the power bi pie chart, the rectangles vary according to the size of the measure they represent.	Each wedge represent a portion of the data
The rectangle in the power bi treemap offers enough space for labeling, the color can be used to signify something else.	The sector/wedges can be color-coded to include another measure.
In treemap, the rectangle can show different levels of data. It is possible to divide the measure into subcategories.	The pie chart can only show one level of data. And it is impossible to divide the wedge of each measure into subcategories.

Read Power BI MAX and MIN function with Examples

Power bi treemap multiple values

Here we will see power bi treemap multiple values in power bi desktop using sample data.

• In the power bi desktop, select the treemap from the visualization pane.
• In the Group field, drag and drop the Sub-category from the field pane.
• In the Details field, drag and drop the category from the field pane.
• In the value field, drag and drop the Profit from the field pane.
• In the tooltip field, drag and drop the sales from the field pane.

• Now when you hover over the treemap, it will display the multiple data labels.
• In the below screenshot you can see the power bi treemap multiple values as multiple datalabels.

Read Power BI Slicer Dropdown

Power bi treemap top 10

Here we will see power bi treemap top 10 in power bi desktop.

• In power bi desktop, select the power bi tree map from the visualization pane.
• In the group field, drag and drop the Sub-category from the field pane.
• In the value field, drag and drop the sales from the field pane.

• Now we will filter the sub-category by top 10 sales.
• Go to filter pane, under filter on this visual, expand the sub category field.
• From filter type dropdown select Top N
• Under show items select 10.
• Then drag and drop the field, based on which you want to filter, here it is sales. Click on Apply filter.

In the below screenshot you can see the power bi treemap top 10.

Read Power BI Slicer Search Box

Power bi treemap drill down

Here we will see power bi treemap drill down in power bi desktop.

• In power bi desktop, select the treemap from the visualization.
• In the Group field, drag and drop the Order date(year and month) from the field pane.
• In the Details field, drag and drop the sub- category from the field pane.
• In the value field, drag and drop the Sales from the field pane.

• Click on the drill down icon, present in the top of the treemap visualization, to expand one level down in the hierarchy.

You can see the power bi treemap drill down in the power bi desktop in the below screenshot.

Read Power BI Slicer Buttons

Power bi treemap multiple levels

Here we will see power bi treemap multiple levels in power bi desktop. We will see three levels of data in the power bi treemap

• In the power bi desktop, select the treemap from the visualization pane
• In the group field, drag and drop the region, segment and category from the field pane.
• In the value field, drag and drop the profit from the field pane.

• Go to formatting section in the visualization pane, turn on the data label

• Click on the drill-down(fork icon) to expand one level down in the hierarchy.

In the below screenshot you can see the power bi treemap multiple levels.

Read Power BI Q&A – How to use with examples

Power bi treemap show value and percentage

Here we will see power bi treemap show value and percentage in power bi desktop.

• In the power bi desktop, select the treemap from the visualization pane
• In the group field, drag and drop the sub category from the field pane.
• In the value field, drag and drop profit from thr field pane.
• In the tooltip field, drag and drop profit from the field pane.

• Under the value field in the visualization pane, click on the drop down.
• Select show value as -> percentage of grand total.

• Now when you hover over the rectangle in the treemap, it will show value and percentage of profit.
• In the below screenshot, you can see the Power bi treemap show value and percentage

Read Power BI Filter vs Slicer

Power bi treemap percentage

Here we will see power bi treemap percentage in power bi desktop using sample data.

• In power bi desktop, select the treemap from the visualization pane.
• In the group field, drag and drop the Region from the field pane.
• In the value field, drag and drop Profit from thr field pane.

• Go to Formatting section under visualization, turn on the data label.

• Go to the Field formmatting section in visualization pane, in the value field click on the drop-down -> Show value as -> grand total percentage.

In the below screenshot you can see the power bi treemap percentage.

Power bi treemap conditional formatting

Here we will see power bi treemap conditional formatting in the power bi desktop.

• In the power bi desktop, select the treemap from the visualization pane
• In the group field, drag and drop the sub category from the field pane.
• In the value field, drag and drop quantity from thr field pane.

• Go to formatting section in the visualization pane.
• Expand the data colors section, and click on the Advanced control.

• Then Data colors window will open, Under format by select Color scale.
• Under Based on field select Quantity. Under Summarization select Sum.
• Under minimum from the dropdown select Custom value and add the value 1000. Similarly select the custom value for maximum and add value as 4500.
• Select the Diverging box to add center value, select custom from the dropdown and add the value as 3500. Click on OK.

In the below screenshot you can see power bi treemap conditional formatting.

Read How to use Microsoft Power BI Scatter Chart

Power bi treemap details

Here we will see power bi treemap details in the power bi desktop.

• In power bi desktop, select the treemap from the visualization.
• In the Group field, drag and drop the Segment from the field pane.
• In the Details field, drag and drop the category from the field pane.
• Make sure only columns can be drag in to the details field, because it is not possible to drag a measure into details field.
• In the value field, drag and drop the profit from the field pane.

In the below screenshot, you can see the power bi treemap details in the power bi desktop.

Power bi treemap change order

Here we will see power bi treemap change order in power bi desktop.

• Power bi treemap will always default to sort by value, highest to lowest.
• In power bi treemap, the top left element will be the highest value.
• In the treemap all other elements are arranged by value flowing down from the top.

You may like the following Power BI tutorials:

• Microsoft Power BI Combo Chart
• Power Bi key influencers
• Power BI Donut Chart – How to use
• Power BI combine columns from two tables
• Power bi create a date table – Complete tutorial
• Power BI Date Function with Examples

In this power bi tutorial, we learned power bi treemap. And also we discuss the below points:

• Power bi treemap
• When to use power bi treemap
• Power bi treemap visual
• Power bi treemap vs pie chart
• Power bi treemap multiple values
• Power bi treemap top 10
• Power bi treemap drill down
• Power bi treemap multiple levels
• Power bi treemap show value and percentage
• Power bi treemap percentage
• Power bi treemap conditional formatting
• Power bi treemap details
• Power bi treemap change orde