Let's say you have some Sales data and you're displaying the Sales for each weekday in the previous week. By doing this with the Superstore data set I get the below chart. See anything wrong with it?
![](https://www.thedataschool.co.uk/content/images/2021/07/image-92.png)
Yep. There's no Monday in this.
How do we solve this? Easy.
Go to 'Analysis' at the top of Tableau, then 'Table Layout', and then (in this case) 'Show Empty Rows'.
![](https://www.thedataschool.co.uk/content/images/2021/07/image-93.png)
Ta-da! Monday has appeared. Now it's clear to the user that Monday was a stinker for sales.
![](https://www.thedataschool.co.uk/content/images/2021/07/image-94.png)
Another example where you'd want to use this feature might be in survey data. If you have a Count of the Responses for each Score from 0-10, you might find that you have some Scores without any Responses. If you exclude these values then it may be misleading for the user.
![](https://www.thedataschool.co.uk/content/images/2021/07/Untitled.png)