Forum Discussion
Not showing zero values on graph object
Hi,
I'm trying to show on a graph the number of documents of my database.
When i have 0 documents i can't see reflected in the graph, however i can see it in a table object.
What i'm doing wrong?
Best regards,
Ricardo Perfeito
5 Replies
But don't you agree that you need to see the zero values?
It can be imporant to analyze our company information, right?
- Hi there - this feature was added since you made your post! You should see an option in the Field Well for the field on your chart's axis to 'Show items with no data'. That will show categories with zero values too. Hope that helps!
By default, Power BI visuals (like bar/line charts) only plot existing data points. If your fact table doesn’t have a row for “0 documents,” nothing shows up.
Fix options:
Use a Date/Category dimension table with all possible values, then relate it to your fact table → chart will show zeros too.
In DAX, wrap your measure with COALESCE([Documents], 0) or IF(ISBLANK([Documents]), 0, [Documents]) so missing values appear as 0.
Turn on Show items with no data (Visual → Axis field → right-click → Show items with no data).
👉 That way your chart will display 0 instead of skipping categories.
