Free tools Windows power users keep installed
One-click scans. No signup required.
You’re not alone: the Power BI setting Show items with no data looks straightforward, but it often fails for real-world models with imperfect date tables, mismatched keys, filters, or measures that return BLANK(). The result is frustrating—categories you expect (zero sales, missing statuses, empty months) simply never render.
This guide treats it like a shipped bug: we’ll define what the option can and can’t do, then walk through the exact UI locations, the model requirements, and the DAX patterns that make empty categories show up reliably.
As an Amazon Associate I earn from qualifying purchases.
What the setting actually does (and when it doesn’t)
Show items with no data tells Power BI to render category members (row/column headers or axis categories) even if the visual’s measure returns no data for them. It doesn’t magically create missing category values—your model still needs a way for those categories to exist in the filter context.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallIn practice, it works best when:
- The categories come from a dedicated dimension table (e.g., Date, Status, Product)
- The visual uses those fields as categorical axes (matrix row/column, chart axis)
- Your relationships and filters don’t eliminate the “empty” members
- Your measure doesn’t suppress display in a way that prevents the visual from treating the item as present
It may appear to “not work” when categories only exist implicitly in the fact table (because there’s nothing to display), when filters remove them, or when the measure returns BLANK() and the visual chooses to hide values.
#1 Best Overall
Prerequisites checklist before troubleshooting
Before changing settings, validate these five basics. They eliminate most failures.
- You added a real categorical field to the visual. For Matrix/Table: add the dimension to Rows/Columns. For charts: add to X-axis (or Y-axis depending on chart type).
- Your category field comes from a dimension table. Example:
DimStatus[Status], notFactSales[Status]. - There’s at least one relationship between dimension and fact. Typically
DimDate[Date]→Fact[DateKey], active relationship. - No slicer/page/report filter is removing the “empty” members. Especially if slicers filter to values that only exist in the fact table.
- You’re testing with a measure that can return 0 or a value for the empty buckets. If your measure returns
BLANK(), the item may render but look empty, or the visual may still not show what you expect.
If you can’t check these, jump to the troubleshooting playbook below and confirm each item in order.
Matrix and Table: the most reliable workflow
Matrix/Table visuals are where Show items with no data is most dependable. Follow this order: confirm the category placement, then set the option in the correct header area.
Recommended Free Tools
Enable Show items with no data in Matrix
- Open Power BI Desktop.
- Select your Matrix visual.
- In the Fields pane, ensure the dimension is in Rows and/or Columns (e.g.,
DimStatus[Status]). - Click the dimension field inside the Matrix well (the token under Rows/Columns).
- In the field dropdown, enable Show items with no data.
If the option is missing, it usually means the field isn’t being used as a categorical hierarchy in a way Power BI recognizes for the visual.
Ensure the measure isn’t masking empties
Even when items render, you might still see blank values and think the setting didn’t work. Check your measure behavior:
- If you want zeros to appear in cells, wrap the measure with
COALESCE. - If you want blanks, keep
BLANK()—but expect “empty” cells.
Example pattern (sales count):
Sales Count = COUNTROWS(FactSales)
If you want empty months/statuses to show 0:
Sales Count (0) = COALESCE([Sales Count], 0)
Line/Bar/Column charts: why categories still don’t appear
Charts behave differently because “items with no data” must be representable on an axis. When the category list comes from the fact table or from an uneven hierarchy, Power BI may not produce members for empty buckets.
Enable the setting on the axis
- Select your Line chart, Clustered column, or Stacked column visual.
- Confirm your category field is in the X-axis (or Y-axis for bar charts).
- Open Format (paint roller).
- Find the X-axis section (or Y-axis depending on chart type).
- Look for Show items with no data and turn it on.
If you don’t see this toggle, it typically means the axis field can’t generate a complete set of categories (again: your axis category must come from a dimension table or a proper date axis).
Don’t test with a measure that filters itself to BLANK
Some measures include conditions that remove rows via FILTER() and return BLANK() rather than 0. The visual may render the axis but show nothing you can clearly interpret.
Quick test: create a new measure that returns a simple numeric value (or 0) for the same context, then compare what changes.
Data model causes: relationships, filter direction, and missing categories
When the setting “does nothing,” the most common root cause is that the dimension members you expect are never reachable under the current filter context.
1) Dimension table is missing the category you expect
If DimStatus doesn’t contain a row for an “empty” status (e.g., a status that currently has no sales), there’s nothing to display. The setting can’t invent members.
Fix: populate the dimension with the full master list of statuses/products/regions.
2) Relationship cardinality and filter direction block expansion
A relationship issue can silently remove dimension members. Common failure patterns:
- Active relationship points the wrong way (filter direction set to single) so the visual context doesn’t reach the fact table correctly.
- Missing relationship between the axis dimension and the fact table you’re measuring.
- Multiple relationships cause ambiguity and Power BI uses an unexpected path.
Fix: In Model view, check the relationship between the dimension containing the categories and the fact table feeding the measure.
3) Many-to-many bridges missing or incorrect keys
If you model a many-to-many (e.g., Products ↔ Campaigns), you often need a proper bridge table. If the bridge doesn’t include keys for missing combinations you expect to show, you won’t get axis members with empty values.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problemsFix: validate bridge keys and ensure they aren’t filtered out by slicers.
DAX causes: BLANK vs 0 and how measures affect visuals
Power BI distinguishes between “no data” (BLANK()) and “zero value” (0). That difference matters for how visuals display cells and how users interpret empties.
Pattern: replace BLANK with 0
Use COALESCE or an explicit IF.
Revenue (0) = COALESCE([Revenue], 0)
This makes empty category intersections show 0 instead of blanks—often the behavior users want when they say “show items with no data.”
Pattern: ensure your measure doesn’t filter out the dimension members
Bad (common) pattern:
Revenue Bad = CALCULATE(SUM(Fact[Amount]), Fact[Flag] = 1)
If Fact[Flag] = 1 eliminates the rows for empty categories, the measure may return BLANK(). Depending on your expectation, that’s fine—but if you want zeros, wrap it with COALESCE.
Better if you want clear “empty” values:
Revenue (0) = COALESCE(CALCULATE(SUM(Fact[Amount]), Fact[Flag] = 1), 0)
Date/time specifics: building a proper Calendar table
If your “empty items” are months, quarters, weekdays, or years, date modeling is usually the cause. Power BI can only show time buckets that exist in your date dimension and are correctly related to the fact table.
Use a contiguous date dimension
A correct Date table should include every date for the range you need (e.g., 2019-01-01 through 2026-12-31), not just the dates present in the fact table.
Typical minimum requirements:
- One row per date
- Marked as a Date table in Power BI Desktop
- Related to the fact table on a date key
Mark the table as Date in Power BI
- Go to Model view or the Data pane.
- Click your Date dimension table (e.g.,
DimDate). - In the ribbon, select Table tools → Mark as date table.
- Choose the date column (e.g.,
DimDate[Date]).
If you don’t mark it, time intelligence and some visual behaviors can become inconsistent.
Rank #3
- Used Book in Good Condition
Ensure the axis uses the date dimension, not the fact
For example, use DimDate[MonthYear] or DimDate[Month] on the chart axis. Don’t use FactSales[MonthYear] if that column only exists for months that have rows.
Filters and context traps (page, report, visual, slicers, drill)
Even with a perfect model, filters can make the “empty categories” effectively disappear.
Slicers that filter to only existing fact values
If your slicer uses a fact column, users can only select values that already exist in the fact table. That prevents the category list from including “zero” members.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Fix: Use slicers sourced from the dimension table (e.g., DimStatus[Status]) and set appropriate slicer behavior.
Visual-level filters removing blanks
Some visuals include a filter like “Show items when the value is not blank.” If applied, it defeats the purpose.
Check:
- Filters → ensure you’re not filtering the measure to “is not blank”
- If you use a hierarchy, confirm drill behavior doesn’t change the axis set
Drill-down and hierarchy level mismatches
When using hierarchies (e.g., Country → State → City), switching drill levels can change which items the visual decides to materialize. Empty cities might not appear if the active level doesn’t include them.
Fix: test at the dimension level you actually want to show, and validate that each level exists in its dimension table.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →Troubleshooting playbook (fast diagnostics in order)
Use this checklist like a decision tree. Each step either finds the issue or narrows it down quickly.
Step 1: Confirm you can see the category member in a plain table
- Create a new Table visual.
- Add the dimension field (e.g.,
DimStatus[Status]) to Rows via the visual fields. - Add your measure as a second column.
If the dimension member itself doesn’t show up, the model or filters are excluding it. Fix that before worrying about Show items with no data.
Step 2: Turn on Show items with no data at the correct field slot
- Open the Matrix field dropdown for the dimension used in Rows/Columns.
- Enable Show items with no data.
- If it’s a chart, enable it under the axis format settings.
If the option is enabled and the item is still missing, something is removing that member from the filter context.
Step 3: Replace the measure with a safe count/total measure
- Create
Row Count = COUNTROWS(FactSales)(or a relevant simple aggregation). - Drop it into the same visual.
If the simple measure shows the empty categories while your original measure doesn’t, your measure logic likely returns BLANK() or applies self-filtering that suppresses results. Wrap with COALESCE or adjust the filter logic.
Step 4: Validate date continuity and relationship direction
- Check that the date axis comes from
DimDateand spans a continuous range. - Confirm an active relationship from
DimDateto the fact date key exists. - Check filter direction if you use composite models or many-to-many bridges.
Step 5: Check slicers, report filters, and visual-level “exclude blanks”
- Temporarily clear all slicers.
- Remove all visual-level filters on the measure.
- Re-test the visual with only the necessary report/page filters.
If it starts working after clearing filters, adjust slicers to use dimensions and remove “is not blank” constraints.
Rank #4
- 336 Pages
- Includes 96 Songs
- Softcover
- Dimensions 12 x 9.5
Common mistakes (so you don’t waste another hour)
- Using fact table fields in the axis. If the fact has no row for a category, the axis can’t show it.
- Relying on implicit month/year columns. If
Fact[MonthYear]only exists for months with rows, you won’t get empty months. - Measure returns BLANK and you expected zeros. If you want visible zeros, use
COALESCEor return 0 explicitly. - Hidden filter rules. Visual-level filters like “Show items when value is not blank” can neutralize the setting.
- Broken relationships or mismatched keys. Key type mismatch (text vs number) or incorrect granularity (date key vs timestamp) can break expansion.
Alternatives when Show items with no data still won’t work
Sometimes you can’t get the behavior you want due to complex filter logic, hierarchy limitations, or unusual modeling. These alternatives are dependable.
Build a complete category scaffold with a dimension
Create or extend a dimension table that includes every category member you want shown (all statuses, all product groups, all weeks). Ensure it’s related to the fact.
Then set the visual to show those members. You’re solving the real issue: missing category members.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Use a “zero-filling” measure strategy
Instead of depending on blanks, return 0 for empty intersections. This makes visuals more consistent across matrix, charts, and conditional formatting.
Example:
Orders (0) = COALESCE([Orders], 0)
For charts: use a date axis that never breaks continuity
If your axis uses a custom hierarchy or an imported “month” column, replace it with a proper DimDate-based hierarchy (Month number, MonthYear text, etc.). Continuity is the difference between missing buckets and visible buckets.
FAQs
Why do I see the category in the Matrix, but the value cells are blank?
Show items with no data can show the header members even when the measure returns BLANK(). If you want 0 displayed, change the measure to return 0 using COALESCE.
My chart axis doesn’t show months with no data. Where do I enable the option?
Charts typically expose it under the axis formatting settings (e.g., Format → X-axis → Show items with no data). Also confirm the axis comes from a proper date dimension that includes every month.
Does this work with DirectQuery and Import?
In general, the behavior depends on the visual, the model relationships, and the availability of dimension members. With DirectQuery, data sources and model definitions still need to support complete category lists—otherwise there’s nothing to display.
Can I show missing combinations (e.g., Product x Status) even when no fact rows exist?
Yes, if you model both sides as dimensions and ensure the fact relationship (or bridge) allows Power BI to evaluate the empty intersections. Then use a zero-filling measure if you want explicit zeros.
Bottom Line
When Power BI Show items with no data doesn’t work, the setting isn’t usually broken—your model, filters, or measure logic is. Use the dimension scaffold + continuous date table approach, then pair it with a COALESCE-style measure when you expect zeros.
If you follow the playbook above—validate category existence, confirm the correct UI toggle, test with a simple measure, then remove filter traps—you’ll find the cause quickly and make empty categories show up reliably.
Free tools Windows power users keep installed
One-click scans. No signup required.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
