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 doin...
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.