Tableau Reference Lines – Add Reference Lines in Tableau
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.
Stay updated with latest technology trends
Join DataFlair on Telegram!!
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.
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:
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:
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.
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