Data Lables Repeating twice in Joining 2 Line Graph

[Niharika_C]

Hi ,

I have Data in this Form .

Till Dec i have COGS Actuals Data (Actual Values), where in from Jan 2023, i have COGS Projected ( these are Predicted Values).

For an Instance, If i represent the same data as a Line Graph, Taking the Actual Values as a Solid Line and Projected Column values in a Dotted Line, 

I wanted to Represent the Pojected column in a Dotted line as they are Future Predictions Value.

So, im getting the graph in the below way.

There is a Gap Between 2 Lines (Solid Line and projected Line )

So, in order to Avoid that Line Gap, i have duplicated the Dec data value from the Actual Data Column in the Predicted column like below.

So, when i Duplicate the Dec Data Value from Actuals coumn to Projection column, there is a Continuous Line Graph for the Visual like below.

Got the Continous line Actuals and Projections.

But, In Graph, for the Dec month, i could see the Data Lables are being duplicated and Occuring twice like below.

So, i want only one data lable value for a Continous 2 Lines Graph. I dont want the Data Lables to be Duplicated and shown Twice.

Need help ASAP on this.

Thanks in Advance.

[amitchandak]

@Niharika_C , That will one line only when you have single measure

sum(Table[COGS Actual])  + Sum(Table[COGS Projected])

If they are measures no need to use sum