CODEWITHSUNDEEP
tableau-desktop
Sparkles the unicorn
Sparkles the unicorn

Reputation: 129

Blank pie charts in Tableau

I have a series of pie charts in Tableau. They are filtered by person. Some people do not have data for some of the pie charts. For example, person 1 might have pie chart a, b, d, but not pie chart c. When this is the case, pie chart c disappears. I would like for pie chart c to show up but be blank. This is to emphasize the fact that there is no data on c for person 1. Does anyone know how to do this?

Thanks!

Upvotes: 0

Views: 651

Answers (2)

Sparkles the unicorn
Sparkles the unicorn

Reputation: 129

After working on this for a while, I have discovered there is a simpler way! Go to your sheet, go to analysis, go to table layout, then click show empty columns. :)

Upvotes: 0

Fabio Fantoni
Fabio Fantoni

Reputation: 3167

Unfortunately, missing data can't be displayed, so assuming you have 3 pie charts, A-B-C, if someone has no data for second pie chart, he/she will see A-C instead of A-#-C (# for blank).

The best workaround may be splitting those 3 charts in 3 separate worksheets. Doing so, you could deliver a more straight forward message playing with tiled and floating objects when it come to build your dashboard.

Like in the following quick example, you may want to use tiled text with "no data" text/image putting the chart above it as a floating object.

enter image description here

Upvotes: 1

Related Questions