PowerBI Pie Chart disappearing when 0 value DAX included

[Perry8]

has anyone else noticed recently (from today 9 Dec) that when the pie chart includes a 0-value measure the pie chart visual just disappears? 

For further clarity, the measure in question is made up of several accounting entries that ultimately evaluate to 0. 

i have used the COALESCE function, and even created a new measure where the formula was " newMeasure = problemMeasure + 0 ", and the pie chart just wouldn't work. 

i used the same measure back in early Oct'24 and the Pie chart worked fine. now in Dec'24 it seems to have broken. 

edit for further context: the pie chart contains other non-zero measures. i cannot share the pbix file as it contains sensitive information. i have removed the problem measures and the pie chart renders fine after that, but if the number of zero-value measures increase, the feasibility of manual intervention decreases and defeats the purpose of using PBI to begin with. 

[Anonymous]

Hi,

Thanks for the solution danextian  , Tahreem24  and 123abc  offered, and i want to offer some more information for user to refer to.

hello @Perry8 , after testing, my resulit is the same as @danextian  provided, it can work, when you have measure with 0.

Or you can try to restore youe desktop to previous version, here is the link to download.

Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

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

[Perry8]

Hi Yolo, thanks for providing the links to download older versions of powerbi! I rolled back PBI back to Version: 2.136.1478.0 64-bit (September 2024) and the pie chart renders properly again. I also have some further questions in mind - I'm not sure if it's because my data source is an SQL server. Or that my measures are negative numbers, although PBI has displayed the negatives as absolute figures on the pie chart anyway, so I don't think that it's much of an issue.

That said, I'm not sure if this is considered a solution since the problem exists in the latest version of PowerBI. I currently don't have the capacity to go down the line of versions to test them all to figure out which version had broken my visuals. Also, not sure if Msft even considers this a problem, but hopefully someone will reach out to me for a longer-term solution.

If there is any more information that you think could help with your troubleshooting, please let me know and I'll try my best to provide it! 

Thanks once again!

[Anonymous]

Hi @Perry8 

Thanks for your reply, you can consider to accept your answer as the solution that more user can refer to.

Best Regards!

Yolo Zhu

[123abc]

This problem might be related to recent updates or changes in Power BI. Here are a few suggestions that might help resolve the issue:

1. Check for Updates: Ensure that your Power BI Desktop is updated to the latest version. Sometimes, bugs are fixed in newer releases.

2. Use IF Statement: Instead of using COALESCE, try using an IF statement to handle the 0-value measure.

   For example:

   newMeasure = IF(ISBLANK(problemMeasure), 0, problemMeasure)

3. Show Items with No Data: Make sure that the pie chart is set to show items with no data. You can do this by selecting the field in the Legend and enabling the option to show items with no d...1.

4. Data Binding: Verify that the correct field is bound to the “Values” section of the pie chart visual...2. Incorrect data binding can sometimes cause issues.

5. Community Solutions: There are discussions in the Power BI community where similar issues have been addressed. You might find additional solutions or workarounds there3.

If these steps don’t resolve the issue, it might be worth reaching out to Microsoft support or checking the Power BI forums for any recent reports of similar problems.

Let me know if you need further assistance!

Community Soved Solution given below:

Solved: Make Pie Chart show 0 when no data available - Microsoft Fabric Community

Solved: Show 0 value on pie chart or donus chart - Microsoft Fabric Community

I hope this helps!
If you found this answer helpful:

Mark it as the solution to help others find it faster.
Give it a kudo to show your appreciation!
Thank you for being an awesome community member!

[Perry8]

thank you for the prompt response! i'm running version 2.138.1203.0 which was up-to-date as of 04 Dec, but seems there was a new update. I'll see if I can get my version updated. will also try out your other suggestions in the meantime! 

[danextian]

Would be nice to be able to see how the pie chart renders if the value is zero. Based on testing, it doesn't disappear. There's just no pie because there's no value to show.

[Perry8]

i'm not sure what your point is here. but for further context, this is a pie chart of a company's balances, as such the pie chart contains other non-zero measures. the pie chart renders fine when i remove the zero value measures, but disappears when i include them. 

[danextian]

I can't replicate your issue or maybe im doing the wrong thing. In the screenshot below, I added a zero value measure but the pie is still there.

This is my version

[danextian]

I'm using the November 2024 version, probably the first iteration.

[Perry8]

interesting.. may i know which version of PBI you're using? 
also thank you very much for troubleshooting it yourself. i can't share my pbix file since it contains sensitive information. 

[Tahreem24]

@danextian I agree with you!