Forum Discussion
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 |
| 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
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
3 Replies
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.
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 😄
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
