Let’s continue working on the page that contains the Treemap visualization! When we point to a data point on the different charts, a tooltip automatically appears for the given part. This can be modified to some extent if we place additional fields into Tooltips at the bottom of the Build visual panel. For example, in the case of the first chart, let’s extend the tooltip so that it also shows the quantity sold. To do this, simply add these fields from both Orders tables.

In addition to this, however, we can also create a completely custom tooltip, let’s see how! Let’s focus now on the Treemap! When we point to a rectangle here, the tooltip shows the county and the total amount due. Our goal is the following. When we point to a rectangle, a bar chart should appear that displays the total amount due broken down by city.

Let’s get started with the task. Insert a new page and give it a name. We will need the Format pane that contains the properties and settings of the page. Right-click anywhere in the middle of the page and from the menu that appears, select Canvas settings! In the Canvas settings section, change the Type to Tooltip! As a result, its size becomes much smaller. This can be adjusted, but it is not advisable to make it too large, because the tooltip itself cannot be too big. The zoom of the workspace can be increased, however, so that editing the visualization is more convenient.

Insert a Clustered bar chart. On the Y-axis, place the City field, and on the X-axis, place the total amounts due from the two Orders tables. Format the chart so that it is still reasonably clear in this small area. Turn off the chart title and the axis titles. Move the legend to the bottom and remove its title as well. Once the chart is formatted, we only need to set that the program should use this page as a tooltip for the Treemap.

Return to our Treemap. Here, the zoom level can be reduced to 80%. Select the chart, and on the Format pane, under the Properties tab, look for the Tooltip section. In the Settings, first choose Report page from the Type list, then from the Page list select the name of the page where we created the bar chart to serve as the tooltip. We are essentially finished, let’s test whether the setting works. 

We can see that everything is fine. The bar chart is always filtered according to the county rectangle we are pointing to on the Treemap.