Forum Discussion
Line chart is not working for zero values
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.
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 quicklyHi 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.
2 Replies
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 quicklyHi 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.