Simple Conditional Formatting in Tableau

2020-01-27T13:10:01+00:00January 13th, 2020|Tableau, Tableau Basic|

Often a client will ask for colourful tables to be built in Tableau, where they want some columns to be highlighted and others to be left un-highlighted. Sometimes this could be called conditional formatting in Tableau. If the requested highlighting is very simple – for example only highlighting Sales by the amount of sales, highlighting [...]

Fix the number of pages to export pdf from Tableau

2019-09-22T11:34:13+00:00September 22nd, 2019|Tableau, Tableau Basic|

Sometimes Tableau developers are asked to create dashboards to download to pdf. Clearly how this looks upon export is key. Therefore the sizing of all components on the dashboard and the page set up is important. Defining the number of pages is straightforward, simply by setting the Print Scaling. In Tableau desktop it's found in [...]

Making Dashboards Relevant

2018-05-07T08:20:31+00:00March 11th, 2014|Tableau, Tableau Basic|

Recently I've seen a lot of sexy dashboards created in Tableau, doing some very cool things. It got me thinking, these look great but actually they're useless, the report users would look at them once, think "wow", and then never use them again as they're not providing any useful information. If you're building reports remember [...]

Tableau Dimensions as Columns in a Table

2018-05-07T18:41:00+00:00December 18th, 2012|Tableau, Tableau Basic|

If you have created tables in Tableau you might have noticed once you get to a six dimension columns  in the table the left hand columns begin to merge into one column. This only happens when using dimensions as column headers, not measures as when displaying multiple measures in a table this can be achieved [...]

Tableau Show or Remove ALL from Autofilter

2018-05-22T19:24:15+00:00June 6th, 2012|Tableau, Tableau Basic|

To remove the All option from a Tableau quick filter is possible by following these simple steps: 1. Click the small down arrow in the quick filter heading 2. Scroll down to Customize 3. Uncheck where it says 'Show "All" Value' so there's no longer a tick mark against it. To show the All option [...]

Tableau Hide Values From a Quick Filter

2018-05-07T19:15:42+00:00April 26th, 2012|Tableau, Tableau Basic|

I’ve had some questions recently about hiding Nulls in a filter in Tableau. This is quite straightforward and the same technique can be used to hide any value from a filter. NOTE – if using this technique it actually removed what you’ve hidden from the filter from the worksheet. All you need to do is [...]

Basic Maps in Tableau

2018-05-08T19:31:35+00:00December 23rd, 2011|Tableau, Tableau Basic|

I’ve been meaning to write about the maps in Tableau for some time now as I’m really impressed with how they look, how easy they are to use and how powerful they are as a visual geographic reporting tool. If you have geographic data, preferably with a longitude and latitude, you can display mapped data [...]

Create a chart in seconds using Show Me in Tableau

2011-10-08T16:04:42+00:00October 8th, 2011|Tableau Basic|

One of the most powerful features of Tableau to a newcomer and those who aren't sure how to display their data is the Show Me! button. Even as an experienced user I often use the Show Me in Tableau when I'm seeking inspiration as to the best ways to display the information in the dashboard. [...]

Tableau Display Measures in a Table

2020-01-27T13:14:20+00:00September 19th, 2011|Tableau, Tableau Basic|

Displaying measures in a table in Tableau is something that should be straightforward but for some reason I always struggle with it hence I’m writing this blog post. In the Tableau screen at the bottom of the Dimensions section there’s a field called Measure Names and in the Measures section there’s a field called Measure [...]