Chart not Showing 0 Value items in the Chart and Blank in Cards

[jamescosten]

I have a chart pulling information from a Sharepoint List that has various filters to show Open vs Closed, Raised in the Month and a Sum Total Back log

The Open Calculation has the follwoing Structure:

Open = CALCULATE(COUNT('Non Conformance Database'[Status]),FILTER('Non Conformance Database','Non Conformance Database'[Status] = "Open"))

The same goes for Closed but if none were closed that month i would like the chart to have a data point of 0 and show zero in the Card. How can i get this to work?

[v-zhangti · Accepted solution]

Hi, @jamescosten 

You can try the following methods.

Open = CALCULATE(COUNT('Non Conformance Database'[Status]),FILTER('Non Conformance Database','Non Conformance Database'[Status] = "Open"))+0

Sample data:

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

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

[jamescosten]

Such a simple fix, Thank you.