Force to show dimension labels even if there are no values Show the Dimension (values even if there is no data for the dimension in the measures, Show all the dimension labels always, regardless of whether or not there is data. It is a simple setting in Tableau and no need to work on any complex sql side manipulations. Go to Tableau desktop Analysis Table Layout Select SHow Empty rows as shown That's it you will see the empty rows now.