Knowledge Drop

Conditional formatting for line chart?

Userlevel 1

Last tested: Jul 22, 2020

There is no way to do this natively, but we can use table calculations as a workaround!


  1. Use if() in a table calc to create the "break" in the line by casting values after a certain point as null. Then create second table calc to cast values before that point as null
  2. Hide the original measure from the visualization
  3. Toggle off "plot null values" in the visualization settings
  4. Edit the series colors + types however you want :)

Some examples:

Screen Shot 2020-07-22 at 9.43.27 AM.png

Screen Shot 2020-07-22 at 9.40.52 AM.png


This content is subject to limited support.                



0 replies

Be the first to reply!