top of page
Bernard K

Tableau Legends per Measure (Separate Legends)

Updated: May 18, 2021


Introduced in Tableau 10.2, legend per measure allows users apply different color legends for highlight tables with multiple measures

Above is an example highlight table with multiple measures – using color to interpret these multiple measures can mislead users as higher values such as Sales can falsify the significance of measures with smaller values such as Discounts and Quantity.

In such cases, legend per measure can help you tell a better story by applying color legend at measure level rather than at global level.

To demonstrate this – let’s, first create a highlight table using dimension Category & Sub-Category with measures Profit, Sales, Quantity & Discount from the Superstores data set.

Creating a highlight table in Tableau

  • Drag dimension Category and Sub-Category to the rows shelf

  • Add measures Profit, Sales, Quantity & Discount to the label shelf

  • Choose text tables under Show Me tab

  • Change marks card from Automatic to Square

  • Drag Measure Values to the color shelf

To enable legend per measure, under Measure Values choose ‘Use Separate Legends

Executing this and editing the legends for each measure we’ve;

This is not the best way to present this data, but when unavoidable – this technique can help you bypass the challenge of having measures with higher values falsifying the significance of measures with smaller values.

To receive more of the Tableau tips and tricks, kindly join our mailing list below

Thanks for reading.

Comentários


Blog.png
Black & white.jpg

About Me

More About the Author

Bernard K

Analytics Consultant | 3X Tableau Certified

Bernard is a data analytics consultant helping businesses reveal the true power of their data and bring clarity to their reporting dashboards. He loves building things and sharing knowledge on how to build dashboards that drive better outcomes.

Let’s discuss your data challenges! Let’s work together!

bottom of page