This might be a starting point.
I created the difference,
then plotted the difference as a stacked bar with the actual profit
colored the actual profit white.
The difference was 60000-sum(profit), but you can make the 60000 a parameter
of the max value + 2000, or whatever you need.
The problem with this method is that the white bars of the actual profit are still
visible when the mouse hovers over them.
invert.twbx 180.0 KB
Thanks for that workaround. Your solution is quite good, however I need to create many many charts and this method may be too manual. I didn't expect Tableau doesn't have such a basic function, unfortunately..
Do you know if version 9.0 offers something more in this matter?
I do not know if 9.0 offers anything more.
If you have to replicate this many times,
I would suggest making a generic template that has parameters for selecting what you want.
One parameter would allow you to select the x-axis categories (Product, Product Line, etc.),
and another for the y-axis metric (Profit, Sales, etc).
Then the calculation would be the window_max(sum(y-axis metric)) - sum(y-axis metric)
invert2.twbx 184.6 KB
I have Tableau version 8.3.2 and cannot open your file because it says it is saved in never version.
Could you please make a screenshot of your calculated field?
You can reverse the axis scale in the axis options (right click on Axis and select edit Axis), and select the Reverse tick box
However looking at your Excel example this isn't quite what you want. Extending on the suggestion from Swaroop, we can use a calculated field that will be dynamic (and so not be set from a manual parameter). In the attached example I've created a field with the formula
So this takes the Max value in view and takes away the actual sales for each category (in my example), so that you get the effect you want.
Hope this makes sense, and is what you were after, but if not please post back and I'll have another go!
Large to Small Bars.twbx 327.2 KB
I made it to the desire state using your method. I also added size mark for the actual profit, and now it is really hard to hover a mouse over it. This method is good but not perfect when it comes to filtering the data (bars' starting point on the bottom is not fixed). However it is better than nothing. Thank you
Also thank you Simon for your reply.
As a 'potential' workaround for the 'problem selecting a zero bar' you could add, say 5000, to the invert metric (or some %age of it, if the scale changes dramatically between measure selection). Now the problem this creates is that the Bars are now 5000 more than the answer, so in order to no mis-lead the end user I've used a bit of visual trickery! I've removed the axis on the chart, and then labelled the bars with the invert metric (the original one, and not the one with the +5000). I've also had to set the text colour to white, as Tableau will show this value for both dimensions, but as the non-viewed one is white this label disappears!
I quite often use this trick to make my viz on one measure (which is for layout purposes) and then label it with the actual measure.
could be over complicating things, but just a thought!!
invert2 - SR.twbx 361.8 KB
Good trick, thanks!