Post1

Formatting Individual Columns in Tableau (Dual-Axis Crosstabs)

Posted by

A simple step by step explanation with screenshots attached!

Tableau can only format based off one value.  For example, you can have a chart that displays Sales and Profit, but you can only set color based on one of them.

 

1

 

What we really need is to be able to apply individual formatting to each column.  This is where the “Dual-Axis Crosstab” comes in.

Here is a step wise analysis

Step 1: 

Create a sample calculated field which will be used as the base for our columns.

 

2

 

Step 2: 

  1. Drag the Calculated Field onto the “Columns” Shelf
  2. Change the “Mark” Type to “Text”
  3. Right-Click inside the Column -> Select “Format” -> Click the Icon that looks like a Pen, -> Remove “Zero Lines”
  4. Right-Click on the Axis Header -> Select “Edit Axis” -> Change the Title to something reasonable
  5. Still in the “Edit Axis” Window, open the “Tick Marks” Tab -> Select “None” and “None”
  6. Drag the Desired Measure onto the “Text” Shelf
  7. Resize the Column

 

3

 

Step 3:

  1. Drag the “Field” Calculated Field to the “Columns” Shelf and place it beside the previous one
  2. Next to the Word “Marks” above the “Marks” Shelf, Select the “Down Arrow” -> Select “Multiple Mark Types”
  3. Now, we can cycle between your different fields
  4. Drag another measure to the “Text” Shelf for the new field
  5. Repeat “Step 2” to clean this column up as well

 

4

 

Now, we can apply individual formatting to each column by cycling through them on the “Marks” Card.  For example, you can color the “Profit” Column by “Profit” and color “Sales” by “Sales.”

Step 4:

Repeat the above process for adding any more measures you want. Add any dimensions you would like, to the “Rows” Shelf

 

5

 

Now, we can see that all “Orange” values should be looked into.

While this is a very simple representation, there is so much more that can be done here.

 

For more such informative blogs, keep a tab on TechBlog!

Until Next Time!

Related Posts

  • Dynamic Pie Charts in TableauDynamic Pie Charts in Tableau

    Tableau is arguably one of the most preferred data visualization tools in the Business Intelligence Industry. It converts raw data into easily understandable formats, enabling marketers, researchers, business owners, and…

  • Removing Default ABC Placeholder in TableauRemoving Default ABC Placeholder in Tableau

    Tableau, a multipurpose tool gives users the freedom to exercise their creativity when developing visually rich reporting. Among its various liberties of building new views, altering the default formats of…

  • Tableau – Sets and Hierarchy functionalityTableau – Sets and Hierarchy functionality

    Business Intelligence and visual data analysis are core requirements of today’s businesses. While there are numerous tools with such capabilities, Tableau is among the most preferred BI tool for its…

  • Show/Hide Filter in TableauShow/Hide Filter in Tableau

    Despite the presence of several quick filters, legends, and other links, we may sometimes require more space to display data in the Tableau Dashboard. There’s, however, a restriction on the…

  • XML Data Processing in TeradataXML Data Processing in Teradata

    XML is a markup language that we can use to format data in a wide range of applications. Teradata Database version 14.10 supports XML as a native SQL data type.…

  • KAFKA-Druid Integration with Ingestion DIP Real Time Data

    The following blog explains how we can leverage the power of Druid to ingest the DIP data into Druid (a high performance, column oriented, distributed data store), via Kafka Tranquility…

One comment

Leave a Reply

Your email address will not be published. Required fields are marked *