Creating a Skyline Chart (Variable Width Column Chart)
Published: 23 Mar 2017
Last Modified Date: 17 Sep 2019
QuestionHow to create a skyline chart.
In this article, we will assume that a company has large sales and high profit rate. In order to replicate this we will want to show a large area in the chart by using the following information:
- A Skyline chart has measures in both X-axis (Sales) & Y-axis (Profit rate).
- Evaluate by the size of area divided by X-axis and Y-axis.
Build the View
- Drag Sub-Category to Columns
- Drag Profit Ratio to Rows
- Sort the Sub-Category Dimension by Profit Ratio
- Right-click the dimension in Columns and select Sort...
- In the Sort By menu, select Field
- Sort Order: Descending
- Field Name: Profit Ratio
- Aggregation: Custom
- Drag Sales to Size in the Marks Cards
Set-up the Skyline View
- Move Sub-Category from Columns to Color
- Ensure the Marks type is set as Bars (and not Automatic)
- Drag another instance of Sales on Rows
- Use the Size icon drop down menu to choose "Fixed" and right-aligned
- Right-click on Sales and select Running Total as a quick table calculation
- In the Calculation Type, choose: Running Total
- Compute Using: Specific Dimension and then tick Sub-Category
To view the steps showed in the below video, please expand the above section.
Note: the video has no sound.