How to show columns forcefully which have blank (or NULL) value for a row in Tableau

I am using Sample-Superstore data set to state the scenario and its solution.

Let’s first create a table which have Categories in columns and days of Order date as rows showing Profit. Filter out it for one month of a year, so I am showing data for December 2014.

How to show columns forcefully which have blank (or NULL) value for a row1

There are missing values on few days for one or two categories.

Suppose if there is a requirement to show only one row for 27th Dec, let’s do it by creating a calculated field:

How to show columns forcefully which have blank (or NULL) value for a row2

So see what happened, the Categories which have NULL value are not getting displayed. If we want to display all categories, whether it has value or it is empty:

Follow below steps:

Go to Analysis Tab -> Table Layout -> Show Empty Columns

How to show columns forcefully which have blank (or NULL) value for a row3

How to show columns forcefully which have blank (or NULL) value for a row4

Similarly we can do for Empty rows also.

Share the joy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Roma

3
Leave a Reply

avatar
1 Comment threads
2 Thread replies
0 Followers
 
Most reacted comment
Hottest comment thread
3 Comment authors
RamRomaIrfan Recent comment authors
  Subscribe  
newest oldest most voted
Notify of
Irfan
Guest
Irfan

I got it. But in data field it is still blank. Can we show 0 if no data available for that column?