Connecting a lines in a linechart

[Puttsson]

Hi,

I'm trying to create a prognosis of the future revenues with 3 different R12-measures.

All looks good. Except that it would be better if I could make the lines start where the previous line ends.

This is how the measures look like in a table. "Revenue R12" only has data till this month, Prognosis Total is based on some activities and previous data, using "ISBLANK" for the months that I don't want to show.

Preferably there would be a setting to connect the dots, but I guess there is non. So then I guess I need to add the last number from Revenue R12 to Total Prognosis for the one month before I have data now. How can I do this? My ISBLANK says: Show Totalt Prognosis when Revenue R12 is blank.

[Puttsson]

Thanks for the suggestion. Works quite okay, but not perfectly as I want it.

I think it would be better if I could find a way to have the line in the same colour as the next period, like in my picture. Any further suggestions to achieve that?

[arichard19]

I would just take a simple approach rather then over complicating it.

Create a measure or a calculated column with all three of them added together. This will create one single long line from Date X -> Date Y

Then create a dax measure to seperate the total column out ->

Highlight =

VAR prog = [Total Prog]

VAR Budg = [Total Budg]

RETURN

IF( prog > 0 || Budg > 0 , [Total12])

Then place both the Total and Highlight measure on the Y Axis of the Chart