Data Labels in Tableau Reports

Data Labels in Tableau reports or any other Business Intelligence reports play a vital role in understanding the report data. For example, By seeing the bar chart or Pie chart, we can easily understand which country sales are higher than the other. However, we can’t see how much sales (in number) each country has done. In these situations, we can enable Data Labels in the country region.

In this article, we will show how to add data labels in tableau reports with example?. For this, we are going to use the SQL Server Data Source. So, please visit Connecting Tableau to SQL Server article to understand the connection process.

Data Labels in Tableau Reports 1

Custom SQL Query we used in the above data source is:

SELECT ProdCat.EnglishProductCategoryName, 
       ProdSubCat.EnglishProductSubcategoryName, 
       Geo.EnglishCountryRegionName, 
       Geo.StateProvinceName, 
       Geo.City, 
       Geo.PostalCode, 
       Geo.IpAddressLocator, 
       Prod.EnglishProductName, 
       Prod.Color, 
       Prod.DealerPrice, 
       Cust.FirstName, 
       Cust.LastName, 
       Cust.Gender, 
       Cust.YearlyIncome, 
       Cust.EnglishEducation, 
       Cust.EnglishOccupation, 
       Fact.OrderQuantity, 
       Fact.TotalProductCost, 
       Fact.SalesAmount, 
       Fact.TaxAmt, 
       Fact.OrderDate
FROM DimProductSubcategory AS ProdSubCat
   INNER JOIN
     DimProduct AS Prod ON ProdSubCat.ProductSubcategoryKey = Prod.ProductSubcategoryKey 
   INNER JOIN
     DimProductCategory  AS ProdCat ON ProdSubCat.ProductCategoryKey = ProdCat.ProductCategoryKey 
   INNER JOIN
     FactInternetSales AS Fact ON Prod.ProductKey = Fact.ProductKey 
   INNER JOIN
     DimCustomer AS Cust ON Fact.CustomerKey = Cust.CustomerKey
   INNER JOIN
     DimGeography AS Geo ON Cust.GeographyKey = Geo.GeographyKey

NOTE: Don’t worry about the code and Joins we used in the above statement. Perhaps you should concentrate on Data Labels. However, If you are interested in learning SQL Server, Please visit our SQL tutorials page.

TIP: This is the query, we are going to use for rest of the Tableau tutorials

Below screenshot will show, the Measures and Dimensions of the Data source

Data Labels in Tableau Reports 2

Before we start enabling the Data labels, we are going to show you, How to Swap rows and columns or else flip the chart. To do this, click on the button we marked below.

Data Labels in Tableau Reports 4

Once you click on that button, you can notice that the chart is swapped or flipped as shown below

Data Labels in Tableau Reports 5

Method 1 to add Data Labels in Tableau Reports

The first method, Click on the Abc button in the Tableau toolbar. From the below screenshot you can observe that when you hover on the Abc button, it will show the tooltip Show Mark Labels 

Data Labels in Tableau Reports 6

Once you click on the Abc button, Data Labels will be shown in the Reports as shown below

Data Labels in Tableau Reports 7

Method 2 to add Data Labels in Tableau Reports

The second method, Click on the Abc Label button present in the Marks Card. From the below screenshot, observe when we Click on the Abc Label button a drop-down window will be displayed.

From the drop-down window, Please check to mark the Show Mark Labels option to enable data labels in tableau reports.

Data Labels in Tableau Reports 9

By using this drop-down window, We can also format the text, color, alignments to the data labels in tableau reports. From the below screenshot, see that we changed the color.

Data Labels in Tableau Reports 10