SPC Charts (Dev) - Correct data imported but giving error in Visual

[F_Reh]

Good evening.

I am working with SPC Charts (Dev) visual...The data for the most recentl three months (November 2024 to January 2025) are showing correctly in the visual..

For example, January 2025 displays as:

However, in spite of importing the correct data for the prior months (September 2024 and October 2024)..

Month	Denominator	Numerator	Percentage
Sep	2978	118	4.0%
Oct	3842	146	3.8%

The visual shows Error output for these two prior months:

I would appreciate some guidance...

Regards

[F_Reh]

Thanks - it was related to being "nulls". I was using two measures:

Denominator_Measure = if(SUM(_Data[X])=0, Blank(), SUM(_Data[X]))

Numerator_Measure = if(SUM(_Data[Y])=0, Blank(), SUM(_Data[Y]))

Now I changed these to:

Denominator_Measure = SUM(_Data[X])

Numerator_Measure =  SUM(_Data[Y])

Now its fine.

However, the reason I did it with the earlier method (IF column = 0 then blank()) is related to an earlier query I posed in a different post to remove the 'NANs' which recommended me to build the measure by that method:

https://community.fabric.microsoft.com/t5/Desktop/NaN-issue-in-Scorecard-Summary-Table-SPC/m-p/43867...

[Anonymous]

Hi @F_Reh ,

Thanks for reaching out.

You could check the data of two months(September 2024 and October 2024) again to see if there's any nulls or other possible errors caused.

You could also try refreshing the report to make sure all data has been loaded into power bi desktop successfully.

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