Tableau can accomplish this using multiple measures and Mark Types to create a view similar to the one below.
We can do this by:
1) Make a “dummy” Calculated Field for the your Header Value equal to 1. (In this example I used Sub-Category)
2) Do the same thing for any Measure Values you want in your view. (for this example I brought in Sales, Profit, and Profit Margin)
3) Start by making a view similar to the one below, with your Header on the Rows and it’s ‘dummy’ measure value on the Columns set to Minimum. Right click on your Header and de-select Show Header.
4) Put your Header (sub-category) on the Label shelf (keep it on the Rows shelf at the same time) You will need to Edit Axis to a fixed 0-1. You may also want to remove Tick Marks and adjust the Title.
5) Put whatever measure or dimension you like on the Color shelf. (I have a KPI on this example) Move the Size slider up all the way. You may want to put a Border around the Color and Format the Label to be Bold/Larger font etc.
6) Bring in one of the ‘dummy’ measure values you created earlier and put it on the Columns shelf. Set it to Minimum. On your Marks card, select Multiple Mark Types. Toggle between the different mark types to see that you can now make different mark types for your first ‘header’ value and your second measure value.
7) Set the second mark type (Sales) to Text and remove anything from the color shelf. Put the real measure value (not the ‘dummy’) on the Text shelf. You may also want to remove Tick Marks and edit the Axis Title.
8) Repeat this with any other measure values you want in your view.
Color the Header.twbx.zip 348.8 KB
Thanks, Jeff! This is great and really helpful. Very much appreciated
Hello Jeff, I need to achieve this solution, I'm trying to follow your instruction but print screen picture are missing, please could you help me.
thanks for your help