Remove Blank Records in Line charts from X Axis data series

[Anonymous]

Hi Team,

Ihave a line chart and a measure is used in Values. The X axis is a date range for last 12 months from the current day.When ever the measure is returing a Blank() i.e no values exists for few dates in the data series, the line is shown as a slant line for these blank() values. How can we avoid these slant lines. I mean can we remove dates in teh series when no values exists for those days..

Regards

Amar

[amitchandak]

@Anonymous , You can make blank as 0 in that case

Measure = sum(Table[Value])+0

[Anonymous]

Thankyou Amit for quick response.

I tried to replace the calculated measure value with 0 when ever we got a blank(), but this is creating all other legends which are not eixisting previously when we had a blank() value. Becaus for all the legends which are not existing previously are now calculated as 0 and showing in the chart..

[harshnathani]

Hi @Anonymous ,

You can try changing the the values to Categorical.

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

[Anonymous]

Thank you Harsh,

When i change it will create a Horizontal Scroll bar and the customer does'nt wants the scroll bar.

Because the line chart is for last 12 months, the customer has to scorll very long to see the pattern(value) changes day by day