Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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:
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
User | Count |
---|---|
77 | |
76 | |
44 | |
31 | |
26 |
User | Count |
---|---|
97 | |
89 | |
52 | |
48 | |
46 |