Conditional formatting for line chart?

[sarah_tayeri]

Knowledge Drop

Last tested: Jul 22, 2020
 

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

Steps:

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:

This content is subject to limited support.