Tableau Reference Lines – Add Reference Lines in Tableau

FREE Online Courses: Click, Learn, Succeed, Start Now!

1. Objective

In this Tableau tutorial, we will study What is Tableau Reference Lines, functions of Reference lines in Tableau and the steps involved in creating / Adding reference lines to the Tableau Bar Chart. At last, we will how to create reference lines in Tableau with example.
So, let us start Tableau Reference Lines.

Tableau Reference Lines - Add Reference Lines in Tableau

Tableau Reference Lines – Add Reference Lines in Tableau

2. Tableau Reference Lines

A reference line in Tableau is simply a line that gets drawn on a chart that represents another measure or point of reference. Tableau Reference lines can be useful in providing context to the related chart. For example, a line showing the median will visually show the difference of each mark in the chart relative to the median.
Read about Tableau Constant Line in detail

3. How to Add Reference Line to Bar Chart in Tableau?

From, following steps, we can create Reference lines in Tableau.

i. From Dimensions, drag Year to Rows.

ii. From Dimensions, drag Genre to Rows to the right of the Year pill.

iii. From Measures, drag Worldwide Gross Amount to Columns.

iv. Hover over the Worldwide Gross Amount axis, and click on the sort icon once to sort the bars in descending order.

Let’s Study About Tableau Stacked Bar Chart

v. On the sidebar, click on the Analytics tab to activate it.

vi. Under Custom, drag Reference Line from the Analytics tab and drop it onto the Table placeholder:

Tableau Reference Line

Step. 6 Adding Tableau Reference Line in Bar Chart

vii. Set the following for this Tableau reference lines:

  • Scope as Entire Table
  • Under Line, setValue, set the aggregation to Average of the SUM(Worldwide Gross Amount)
  • Under Line Label, set it to Custom with Average <Value> as text; note you can use the > button to insert values
  • Under Formatting, set Line to a thick, dark red line
  • Under Formatting, set Fill Above: to None
  • In Under Formatting, set Fill Below: to None:
Tableau Reference Lines

Step. 7 Adding Tableau Reference Line in Bar Chart

Let’s look at Tableau Trend Line and How to Create Trend Line

viii. Click OK when done.

ix. Under Custom, drag Reference Line again from the Analytics tab and this time drop it onto Pane.

x. Set the following for this reference lines in Tableau:

  • A scope is Per Pane
  • Under Line Value, set the aggregation to Average of the SUM(Worldwide Gross Amount)
  • Under Line Label, set it to Value
  • In Under Formatting, set Line to a thick gray line
  • Under Formatting, set Fill Above to None
  • Under Formatting, set Fill Below to a light yellow color

xi. Click OK when done.

This was all about Tableau Reference Lines Tutorial. Hope you like our explanation on Reference Lines in Tableau.

4. Conclusion

Hence, in this Tableau tutorial, we study about what is Tableau reference lines, steps involved in creating them Reference lines in Tableau and how to add reference lines in Tableau bar chart. Furthermore, if you have any query feel free to ask in a comment section.
Related Topic- Tableau Reporting 
For reference 

Did you like our efforts? If Yes, please give DataFlair 5 Stars on Google

follow dataflair on YouTube

Leave a Reply

Your email address will not be published. Required fields are marked *