Line on Clustered Chart is not continued

[rocky09]

can any one advise, why the line on my clustered chart is not continued. See below.

Thank you in advance,

[MFelix]

Hi @rocky09,

This as to do with the fact that you have null / blank / inexisting values on the data base, not sure how you have the model setup if you have a Calendar table, if you are using measures but you can do one of two things:

• Advance query editor replace null by 0 on the fields you are using for your charts
• Make a measure that would look something like this:

lines_mesarue = IF( ISBLANK(SUM(Table1[Lines])); 0; SUM(Table1[Lines]))

Then result would appear like this:

Regards,

MFelix

[rocky09]

@MFelix

Thank you for your reply.  Actually, I have these values for different types, lets say, ABC, CBA, DCA,

for counting/plotting the line,  i am using the below measure.

NoofErrors = CALCULATE(COUNT(Quality[Key Process]),Quality[Key Process]="ABC")

[MFelix · Accepted solution]

Hi @rocky09

Try to do something like this:

Measure = IF (ISBLANK (NoofErrors); 0 ; NoofErrors)

Regards,

MFelix

[Anonymous]

Hi @rocky09,

Did you check if your axis type is Continuous or Categorical?

[rocky09]

@Anonymous

Thanks for your reply. Actually, I don't see any Categorical or Continuous in the X-Axis, may be because of I am using Date Hirerachy just only Year and Month.