Using symbol fonts in Tableau number formatting

In his post at https://www.tableau.com/about/blog/2016/5/information-demand-54621, my Slalom colleague John Mathis uses an interesting custom number formatting trick that shows arrows indicating an increase/decrease over prior year.

dashboard_kpi_arrows_circled

This post explains how to do that.

Open the Windows application Character Map by either 1) typing [Windows] + R then “charmap” or 2) typing [Windows] + S, search for “character map”, click on Character Map.

open_charmap

search_charmap

Select the “Segoe UI Symbol” font.

select_font

In the “Search for:” box at bottom, type “triangle” and click the Search button.

search_results

Double-click on the “Black Up-Pointing Triangle” and “Black Down-Pointing Triangle” symbols to add them to the “Characters to copy:” box.

add_triangles

The two symbols are automatically copied to the Windows clipboard, but you can click the Copy button to make sure.

Go to Tableau Desktop and paste the two arrows into the field’s default number format.

tableau_number_format

tableau_paste_triangles

Add more text to the custom format as needed.

tableau_final_number_format

You are done!

Leave a Reply