Power BI Treemap

Treemap is used to display large amounts of hierarchical data in Rectangle boxes.

Each level of the hierarchy is represented by a colored rectangle, known as “branch”. If you add a category into the Details section of the visual, it will divide the branch into smaller “leaves”, hence the name Treemap.

So, Let’s start with an example, download the sample Dataset from below link

• Global Super Store Dataset

Step-1: Add Treemap visual to report page > Drag “Sub-Category” to Group & “Sales” to Values section.

Step-2: Now set the formatting for Treemap, some important properties as below:

• General: Allows you to set X axis, Y axis, width & height of Treemap visual.
• Data colors: Using this section you can change the colors used for each category in the visual.
• Y-Axis: Using this section allows you to modify the appearance of the Y-Axis section of this visual.
• X-Axis: Using this section allows you to modify the appearance of the X-Axis section of this visual.
• Category: Its enables the categories name on Treemap.
• Data labels: Its enable values on visual & you can change the color, background color, display unit, font size, font family of Data labels.
• Title: Specified the Title name for Treemap.

Step-3: Now Drag “Category” in Group, “Sub Category” in Details & “Sales” in Values sections.

Now you can see the “sub category” wise sales under each category rectangle box.

Treemap visual after formatting:

When to use a Treemap?

• To display large amounts of hierarchical data.
• When a bar chart can’t effectively handle the large number of values.
• To show the proportions between each part and the whole.
• Show the pattern of the distribution of the measure across each level of categories in the hierarchy.
• To show attributes using size and color coding.

Want to know about other visuals, refer this: Power BI Visualizations

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our Contact form , we will revert to you asap.