Can we make two colors in a single line chart

I'm creating a card using a multi-line chart and one of the requirement is I need to change the color for all the previous months indicating that these month were already actual.

For example: Oct, Nov and Dec must be put green colors then Jan onwards will stay orange color.

Capture.PNG

Comments

  • The way you would need to do that is to break the lines up in the previous and future values. So based on your example, instead of using 1 measure and a category to split the line into the blue and orange lines. You would instead create 4 beast modes, 2 for your previous (actuals) and 2 for the future values.

    Β 

    Example beastmode:

    /* Previous */
    CASE WHEN `Date` < CURRENT_DATE() AND `Category` = 1
    THEN `Value`
    END

    /* Future */
    CASE WHEN `Date` >= CURRENT_DATE() AND `Category` = 1
    THEN `Value`
    END

    As long as you don't add a category at the end of your columns when building the line chart, you can add as many measures as you want.

    Β 

    Hope that helps, let me know if you have any questions,

    Valiant

    Β 

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

  • @ValiantΒ  It's seem work but there is a new problem arise the line got disconnected since I split the actuals and the forecast. Any idea?image.png

    Β 

    image.png

    Β 

This discussion has been closed.