This is a Quick Tip on how to build a Rounded Bar Charts in Tableau, so less reading and more jumping in. We are going to spend 5 minutes or less building our Rounded Bar Charts in Tableau.

Note: As always never choose a data visualisation type and try to fit your data into it, instead, understand your data and choose the best visualization for your data consumers.

Data

Load the following data into Tableau Desktop / Public.

TypePercentage of Population
ISTJ0.116
ISFJ0138
INFJ0.015
INTJ0.021
ISTP0.054
ISFP0.088
INFP0.044
INTP0.033
ESTP0.043
ESFP0.085
ENFP0.081
ENTP0.032
ESTJ0.087
ESFJ0.123
ENFJ0.025
ENTJ0.018

Calculations

With our data set loaded into Tableau, we are going to create the following Calculated Field:

Zero

0

Now that we have the Calculated Fields created, let us start building our dashboard.

Worksheet

To start building our dashboard:

  • Drag Measure Name onto the Filters Shelf.
    • Untick Number of Records.
  • Drag Measure Values onto Columns.
  • Drag Myers Briggs onto Rows.
  • Drag Myers Briggs onto Color.
  • Change the Mark Type to Line.
  • Drag Measure Name onto Path.

If all goes well, you should see the following:

Now adjust the cosmetics of the visualisation:

  • Drag Myers Briggs onto Color.
  • Remove Grid and Zero Lines.
  • Add Percentage of Population to Label and format.
  • Format the Percentage of Population to a one decimal percentage.
  • Add Sort Order.
  • Add Highlighter.

You should now see the following:

and boom, you can experiment with a variety of shapes and include quarters as well as half values. However, we are done and you can find my Visualisation on Tableau Public at https://public.tableau.com/profile/toan.hoang#!/vizhome/RoundedBarCharts_5/RoundedBarCharts

Summary

I hope you all enjoyed this article as much as I enjoyed writing it. Do let me know if you experienced any issues recreating this Visualisation, and as always, please leave a comment below or reach out to me on Twitter @Tableau_Magic.

If you like our work, do consider supporting us on Patreon, and for supporting us, we will give you early access to tutorials, exclusive videos, as well as access to current and future courses on Udemy:

Also, do be sure to check out our various courses:

12 COMMENTS

  1. Hello Mr.Toan, thanks for the tutorial, i have a question, what for we use the calculation ZERO?, i have done the steps but at the end i have get a chat with an axis start from negative values and not from 0.

  4. Hi Toan, thank you for the tip.
    I have a problem, because I also need to add an average line, but after I add 0 its shows wrong value.

    So I have 10 stores with numb. of units from 190 to 680, an avg. line must be 380,2
    But now it shows avg. twice less – 190,1

    Maybe I can do smth with this?

  5. Thanks very much for posting, Toan.

    I did have a couple of issues, so hopefully these points might help other people:
    – In the dataset, “Type” needs to read “Myers Briggs”.
    – In the value for ISFJ, add a decimal point so it reads “0.138”.
    – To hide the markers (large dots) at the end of each bar, click Color, then under Markers choose None.

    One issue I couldn’t solve – dropping the Percentage of Population field onto Label makes Tableau put the values at BOTH ends of each bar. How do you prevent that?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.