Line chart show a gap if i use both legend and error bars

[rufmau68]

Hi everybody,

i have data like this 

and i need to show somethink like this where i have error bars showed, and the line in Y-axis with double color depending on legend value

but if i select a legend field PBI use 2 colors in the line (good) but create a gap in the line (bad), if i dont select a legend field PBI no gap showed (good!) but color all the line with a single color (bad):

https://github.com/mauroruffinocsi/pbi/blob/67d61449d5459a4046e5f826376da72333ebed04/finta%20previsi... 

can anyone helps me to optain the desired configuration ?

thanks

bye

mauro

[MFelix · Accepted solution]

Hi @rufmau68,

The question is that you have gap between both this values on your data when one ends the other one starts

Do the following:

Create two measures:

Stimato = SUM(Tabella[Valore])
Valore Reale = CALCULATE(SUM(Tabella[Valore]), Tabella[Tipo dato] = "Valore reale")

Now add the measures with stimato first and realle in second then do your error bar based on the stimato: