Wednesday, September 16, 2015

Create a Treemap Graph in SQL Server Reporting Services 2016 by Koen Vereeck

https://www.mssqltips.com/sqlservertip/4023/create-a-treemap-graph-in-sql-server-reporting-services-2016/

MSSQLTips author Koen VerbeeckBy: 






Problem
At the time of writing, SQL Server 2016 preview (CTP 2.2) has been released and it contains a few exciting changes for SQL Server Reporting Services (SSRS). One of the new additions is a new chart type: the treemap. This tip will give an introduction on how to create a treemap graph.
Solution

Test Data

First of all, we need data for our treemap. In the tip Retrieving file sizes from the file system using Power Query it is explained how you can use Power Query to extract the file sizes of all the files in a folder and its subfolders. The resulting data looks like this:


read on from the above link

No comments:

Post a Comment