KNOWLEDGE BASE

Cannot Set "Force the Y-intercept to Zero" When Using Continuous Dimensions


Published: 05 Oct 2021
Last Modified Date: 05 Oct 2021

Question

"Force the y-intercept to zero" in Trend line option is grayed out when using continuous dimensions on Tableau Desktop 2020.2 and older.
User-added image

On Tableau Desktop 2020.3 and later, this option is available but does not work as expected.
User-added image

Environment

  • Tableau Desktop 2020.2 and later

Answer

Possible workaround:
  1. Change the continuous dimensions to continuous measures.
  2. Set "Force the Y-intercept to Zero"  in the Trend Line Options window.
  3. Change the continuous measures back to continuous dimensions.
User-added image
Please check the attached workbook for details.
Did this article resolve the issue?