Usage of TREEMAP data visualization in Power BI

A treemap represent an entity of items in a rectangle where each item occupies a rectangle and all entities are inside the single rectangle( not unlike a map of a state containing all the counties, a map unlike treemap is not in a rectangle).

This is supported visualization type in Power BI.

Treemap.png

I am using the data from this post  of filtered sales by employees in the Northwind database on SQL Server 2016 using a direct query.

On a new page, click treemap under visualization to add the treemap to the page as shown,

Treemap_0

Drag fields LastName and UnitPrice to the treemap and the treemap changes as shown. Each rectangle now corresponds to an employee with its area in proportion to the sales made by the employee.

Treemap_00

You can add other formatting as shown

Treemap_000

You can add Spotlight to the treemap using the Spotlight menu as shown.

Treemap_2

You can also add tooltip in the Group page.

Treemap_3

Enhancement to Donut / Pie chart in June 5, 2018 BI Update

Again this feature is available in the June 5, 2018 update of Power BI.

Visual appeal is really important and Power BI now supports labelling inside or outside the Donut and Pie charts.

We use the same data used in the previous example of controlling the inner radius of Donut control used in data visualization described in this post.

Here the labels are outside the Donut.

Here is how you make them move inside the Donut.

You can also have label's text to overflow if it is not contained.

Some labels inside and others outside.

Overflow set to Off.

In the same way PIE Charts are also handled.

Enhancement to Donut chart in June 5, 2018 Update of Power BI - 1

Visual appeal is everything for anything. It is also called eye candy, loosely put. It is aesthetics that matters.

For Donut charts this makes a big change. Now you can control the inner radius.

This is a new feature of June 5, 2018 update for Power BI. You need to install this version first before you follow this post.

Get some fields' data into Power Bi by connecting to your datasource as in this post.

Drag and drop a Donut Control to your page as shown.

Donut_00

Place check marks for the data in Query1 as shown.

Donut_0

Click Format shown here:

Donut_1

The default is Inner Radius=60%

The next two figures shows for 28% and 88% inner radii.

Hands-on Learning Event in Honolulu 1 : Introduction to Structured Query Language

Register here:

Update your Power BI and test drive new features

Get the latest June 5, 2018 version of Power BI Desktop from here:

https://powerbi.microsoft.com/en-us/desktop/?WT.mc_id=Blog_Desktop_Update

Get all the Power BI related posts on this site:

HodentekMSSS -Pure SQL Server

Get the version suited to your architecture.

List of new features and stuff (copied from Power BI site):

Here’s the complete list of June updates:

Reporting

• High contrast support for reports
• Donut radius control
• Pie and donut detail labels position control
• Format data labels separately for each measure in a combo chart
• Longer phone reports

Custom visuals

• Organization Chart
• China Heat Map

Modeling

• Filtering and sorting in data view
• Improved locale formatting

Data connectivity

• SAP BusinessWarehouse connector improvements
  • New driver and improved performance
  • Improved support for hierarchy variables
• Spark connector now supports Windows Authentication
• OData V4 connector enhancements
• ODBC connector improvements
  • Folding support for Top Rows
  • Ability to filter navigation by DSN catalog

Other

• National cloud selector