Repository of Useful Links for Tableau Development
- Aurora Broom
This page serves as a repository for articles that showcase useful and interesting ways to use Tableau.
Title | Key Words | Description | Link |
|---|---|---|---|
How to solve overlapping axis labels for bar charts | Axis, labels | By offsetting every other label in a bar charts axis, we can show axis labels more clearly without rotating them. | |
Creating shifted/overlapped bars | Bar chart, display | Create a unique bar chart with comparison columns sat behind recent columns. Used in the CAS Status Report. | |
Moving marks to front or back | Dual axis, display | Changing the position of marks on a dual axis chart by right clicking on the axis and selecting the appropriate action | |
Changing the alias of the in/out terminology used for set filters | Aliases, sets | When a set is created and you want to use a filter to view items in and out of the set, instead of the filter option simply showing in or out, you can customise the aliases by dragging the filter onto detail and right clicking to select alias from that pill. | |
Sort the order of items in a filter | Filter, sorting | Right click on the field in the data pane → default properties → sort | |
Display text/labels depending on their position in a list | Custom text, display | Create a calculated field and using LAST() = 0 or FIRST() = 0 to determine what marks show labels. Useful if wanting to show the difference in values b/w the start and end of a time series, for example. | |
How to show a zero value or message when there is no data in the view | Data, zero | This is useful in scenarios where there is a risk that users will filter out all the data in a view, then be confused that their screen is blank. Aurora used this functionality in the Portfolio Explorer. | https://www.youtube.com/watch?v=HNtrDFpY5_E&ab_channel=DataVizCanvas |
Make a line chart continuous, even when values are null or don’t exist | Zero, display, line chart | For null data: ZN(SUM([Applications])) For missing data: ZN(SUM([Applications])) * (IIF(INDEX() >0, 1, 1)) | A Solution to Tableau Line Charts with Missing Data Points - InterWorks |
|
|
|
|