Tag Archives: conditional formatting

Conditional Formatting

Conditional Formatting Equivalents

The most complete post on conditional formatting in Tableau is this one: http://drawingwithnumbers.artisart.org/older-but-still-useful-conditional-formatting/, which describes the multiple axis crosstab here: http://public.tableausoftware.com/views/conditionalformattingv4/Introduction. Other than the Formatting Numbers section, most everything else is covered in that post & workbook.

Building a Measure Names/Values Table – Have only One Measure on Measure Values Card

Put Measure Names on the Filters Shelf first and keep only the desired Measured Value(s), possible to have just one Measure Value this way and still have a header. http://community.tableausoftware.com/message/214871#214871

Formatting Numbers



Creating custom color palettes

highlighting specific rows: Rapid Graphs by Stephen McDaniel and Eileen McDaniel, http://www.freakalytics.com

aligning shapes for marks: mark_align.twbx file by Joe Mako in http://community.tableausoftware.com/thread/113351

setting up custom highlight table: margin_zone.twbx file by Joe Mako in http://community.tableausoftware.com/thread/110007


Make an “empty” header:

Force Tableau to show text headers in a row and not hide them in cross-tab display:

Removing last column (Abc column)


Crosstabs and Text Tables

Putting more columns than the default 6 on tables – from the menu bar, select Table->Options and increase the number of columns

[loop category=”wikicontent” tag=”conditional-formatting,formatting,Excel,format”]
[field title] – Added [field date]

Related posts:

    [loop tag=”conditional-formatting,formatting,Excel,format” exclude=”this” relation=”and” compare=”not” taxonomy=”category” value=”wikicontent”]

  • [field title-link][field thumbnail-link]


KPIs and Floating Dashboards

I haven’t seen this particular trick out there yet, it’s a fun one for the toolbox. When we’ve wanted to mix and match KPIs in a crosstab or text table, we’ve had to resort to multiple worksheets on a dashboard in a layout container, or a multiple axis crosstab. The former can result in various display issues because Tableau imposes certain border sizes, the latter has problems with performance due to the number of separate queries and computations that are necessary.

Tableau version 8 gives us floating dashboard elements with pixel-level precision for element location, and that gives us a third way to build text tables with KPIs.

Continue reading

Measure Names on the Color Shelf: Tableau v8 Enhancements

Tableau version 8 “The Kraken” is in beta right now, and Tableau is also beta testing Tableau Public for the new release, and they’ve kindly given me access to it. Tableau v8 is a huge release, as I’m exploring it I’m finding some subtle and not-so-subtle differences. In the coming weeks I expect to do a series of posts on how those changes affect my workflow, and/or relate to prior posts of mine.

I’m going to focus on the new feature that enables multiple discrete (blue) pills on the Colors Shelf of the Marks Card, in particular how it interacts with the Measure Names pill and makes possible some things that were much more difficult to to in prior versions of Tableau.

Continue reading

Older But Still Useful – Conditional Formatting

Back in May of this year before I started this blog, I did a presentation at the Boston Tableau User Group on conditional formatting in Tableau. Prior to using Tableau, I’d created some dashboards and reports in Excel, and when I tried to re-create them in Tableau I ran into a number of different issues in terms of doing the kinds of formatting, layout, and conditional formatting that are possible in Excel. I created a workbook with every technique I could find and some I figured out. Continue reading