Forum Discussion

Icon for Solution Sage rank

Solution Sage

8 years ago

Solved

Line on Clustered Chart is not continued

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

Thank you in advance,

MFelix
8 years ago
Hi rocky09

Try to do something like this:

Measure = IF (ISBLANK (NoofErrors); 0 ; NoofErrors)
Regards,
MFelix

5 Replies

Anonymous
Not applicable
8 years ago
Hi rocky09,

Did you check if your axis type is Continuous or Categorical?
- rocky09
  Solution Sage
  8 years ago
  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.
MFelix
Super User
8 years ago
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
  Solution Sage
  8 years ago
  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
    Super User
    8 years ago
    Hi rocky09
    
    Try to do something like this:
    
    Measure = IF (ISBLANK (NoofErrors); 0 ; NoofErrors)
    Regards,
    MFelix