Hi all!
I have been working on a dashboard at work that requires the ability to have consistent sizes of marks across multiple worksheets. I found a solution that worked for me, so I thought I would put a quick blog out on it.
The simple example I will use is the one below, where I have two sheets showing ‘Action Dots’ next to each bar chart. I want the sizing of the dots to be consistent:
The size I wanted was outside of the usual ‘Snap to size’ option you get on the default Tableau slider:
This is where the slider will stick to the points marked on the line.
However in my dashboard, neither of these ‘Snap’ sizes worked for me – I wanted something in between. The problem with this is that you can’t set this slider to more than one worksheet, so you are faced with estimating the slider individually on each sheet and making sure the sizes all stay the same by eye.
The solution I have found makes use of a parameter to control the size, and some settings changes in the size mark card. I will shout out to my colleague Matt who helped clean up my initial solution (believe it or not I hadn’t used a parameter originally!) and made it work smoother! Here is how the solution looks in the final state:
And the steps I took were as follows:
Create a size parameter which is an integer, range 1-100:
Put this parameter onto the ‘Size’ shelf of the first worksheet you want to be sized this way:
Edit the ‘Sizes’ card when this pops up on the screen:
Change the ‘Sizes Vary’ to ‘By Range’ and set the start and end values to 1 and 100 (same as parameter):
Repeat this size shelf activity for each worksheet you need to be consistent, and then once set up, the parameter will control all the sizes, and you have a precise range of values to set it to.
And that’s it! I hope this may be of use. I’d be keen to hear if anyone has gotten around this via any other means!
Public link to the above dashboard is here:
Ant.
Ant Pulley | Blog 