Forum Discussion

calloni's avatar
calloni
Helper I
2 years ago
Solved

Line graph with 2 colors

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 ...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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's avatar
mickey64
Super User
2 years ago

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's avatar
calloni
Helper I
2 years ago

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 😄