Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
can any one advise, why the line on my clustered chart is not continued. See below.
Thank you in advance,
Solved! Go to Solution.
Hi @rocky09
Try to do something like this:
Measure = IF (ISBLANK (NoofErrors); 0 ; NoofErrors)
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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:
lines_mesarue = IF( ISBLANK(SUM(Table1[Lines])); 0; SUM(Table1[Lines]))
Then result would appear like this:
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThank 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")
Hi @rocky09
Try to do something like this:
Measure = IF (ISBLANK (NoofErrors); 0 ; NoofErrors)
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@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.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |