Line graph with 2 colors

[calloni]

Hello

I have this table and I need to graph it as a line chart where I have a continuous line that will have 2 colors depending on the Line color column definitions:

Date	Y axis	Line color
6/29/2017	1	Gray
5/2/2018	1	Gray
11/3/2022	1	Gray
7/11/2024	1	Orange
11/3/2024	1	Orange

Note: I am using the Y axis dummy value as 1 just to make the line straight.

However when I use the line chart option in Power BI I get two lines that don't connect to each other:

I wonder what is wrong on my data model that is generating this break in the line?

What would it be the options to adjust this?

Thanks in advance

Rodrigo

[Ritaf1983 · Accepted solution]

Hi @calloni 

**"The "gap" in your data is created because the data is not continuous once you split it into 2 lines. The gray line ends before the orange line starts.

If you want to get a graph like the one in the picture where the gray line is present until the orange line starts, you can artificially create it with 2 measures.

Grey = sum('Table'[Y axis])

orangeline_ = CALCULATE(sum('Table'[Y axis]),'Table'[Line color]="orange")

The pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[mickey64]

For your reference.

Step 0: I use this data table below.  (I add 2 rows to the table.)

Step 1: I make a line graph.

[calloni]

Thanks... I will go with Ritaf solution for this one as I dont need to change the data as you are proposing... but this made me understand that this is basically overlapping 2 bars to make it work which is really scary 😄