Data Viz Done Right

June 28, 2016

Tableau Tip Tuesday: How to Display KPIs Next to Bars


This week’s tip shows you how to perfectly positive KPIs next to bars irrespective of the dimensions in the view. This started as a Data School Gym Challenge if you’d like to have a go at it before you watch the video.


  1. Thanks Andy for the great tip.

    I'm facing difficulty in hiding negative values from the axis header. Appreciate any help.

    Also I was wondering how to replace dimension values with shapes in tables or charts.

    Thanks again.

    1. Hi Shivraj,

      I encountered the same issue with hiding the negative value. What I did was changing the Mark Position calculated field by : AVG (-5000). Then I made my bottom axis fixed starting to -8000 so the mark position wouldn't be too close from the bars. You can play with both until you like the result.
      Hope that helps!


  2. This is great! But what are the potential implications if your dataset has negative data in it - would you just use a different negative avg for placement or could you make the placement value dynamic as compared to the min of the data set?
    Also, I would bet someone would want the negative value on the axis suppressed for this. Suggestions?

  3. Thank you Andy, this is very practical.
    I downloaded your workbook and I have one question:
    If I bring up a date filter to the view and decide to change my latest year so I want to look at 2014 vs 2013, it is not working anymore. How can I be flexible and change my latest year?

    Thanks a lot!


    1. If you use a date filter, then you're filtering the data, so of course it won't work. You'll need to use a different calculation. See if you can figure it out. It's a good test for you.

  4. Hello

    Thanks for video. I am blocked by the fact that my "Sales" is an aggregate (using countd formula) which is mandatory. Any idea on how to get around that?
    I would really like to be able to follow.
    Thanks a lot