#How to - Single Drill Down Bar Chart

How to Create:

1. Create a region set and add a region to it.

2. Create a region to category calculated field.

3. Configure as follows:

Drag Region and calculation from step 2 into rows and sales into columns. Drag your region set onto the colour mark.

4. Hide the field 'Region' and hide the field label for 'region to category'.

5. Create the action that will edit the set depending on which region you click.

Add a 'Change Set Values...' action and configure to look like the right image. You want to assign values to the set and remove all values when the set is deselected. 

6.  Create a rotating label:

7.  Format as desired.

Author:
Amelia Holland
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2024 The Information Lab