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

http://www.clearlyandsimply.com/clearly_and_simply/2011/04/tableau-quick-tip-2-custom-number-formats.html#more

http://community.tableausoftware.com/thread/118621

Creating custom color palettes
http://kb.tableausoftware.com/articles/knowledgebase/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

http://www.tableausoftware.com/support/forum/topic/conditional-formatting-columns-cross-tabs-conditional-appearance-marks-0
http://www.tableausoftware.com/support/forum/topic/conditional-formatting
http://www.tableausoftware.com/support/forum/topic/conditional-background-formatting
http://www.tableausoftware.com/support/forum/topic/conditional-formatting-columns-cross-tabs-conditional-appearance-marks
http://www.tableausoftware.com/support/forum/topic/conditional-formating-measures
http://www.tableausoftware.com/support/forum/topic/how-can-i-do-these-things
http://www.tableausoftware.com/support/forum/topic/shape-alignment#comment-39152

Make an “empty” header:
http://www.tableausoftware.com/support/forum/topic/output-particular-format-column#comment-43090

Force Tableau to show text headers in a row and not hide them in cross-tab display:
http://community.tableausoftware.com/message/172574#172574

Removing last column (Abc column)

http://community.tableausoftware.com/message/174253#174253
http://kb.tableausoftware.com/articles/knowledgebase/removing-abc-placeholders

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]
[content]
[/loop]

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]

[/loop]

One thought on “Conditional Formatting

Please add your thoughts and perspectives