Line chart is not working for zero values

[ashikalahi333]

In the attached line chart with green line for 3rd sep and 10 sep the distinct count is 1 but for 17 and 24 sep the value is zero but the line is not decreasing to bottom for zero values. I need suggentions for this. Thanks is advance. I already use +0 in the measure but it didn't work.

[Ritaf1983 · Accepted solution]

Hi @ashikalahi333 
Try to change a type of X-axis to "continuous" from format options >>x-axis >> type.

If it won't help share the link for dummy pbix to work with.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous · Accepted solution]

Hi @ashikalahi333 ,

You can try modifying as

Public Liability Count (Unique Property) = var _a=CALCULATE(DISTINCTCOUNT(QSFExpiredContractorLiabilityAndInsurances[Name]), FILTER(QSFExpiredContractorLiabilityAndInsurances, QSFExpiredContractorLiabilityAndInsurances[Public liability Copy] = "1"))
return IF(ISBLANK(_a)&&NOT(ISBLANK([Trade License Count])),0,_a)

Here's the result.

By the way, pay attention to protect data privacy, this is a public forum.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Ritaf1983 · Accepted solution]

Hi @ashikalahi333 
Try to change a type of X-axis to "continuous" from format options >>x-axis >> type.

If it won't help share the link for dummy pbix to work with.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly