Easy Tech TutsHow to Show Items With No Data in Power BI (Stop Missing Categories) Easily 2026
By Impran M N
By default, Power BI can hide categories that don't currently have data, which means viewers may not realize a category exists at all. This guide explains how to make those items visible so your reports show a complete picture. It's a useful fix for sales, marketing, and inventory reports where missing categories can be misleading.
01Identify the missing categories issue
Check whether categories without current data are being silently excluded from your visual, which is the core problem this setting addresses.
02Adjust your visual settings
Enable the option that forces the visual to display all categories, even ones that currently have no associated data points.
03Confirm every category now appears
Review the updated visual to make sure previously hidden categories are now visible alongside the ones that do have data.
04Apply it to real business reporting
Use this setting in scenarios like sales analysis or marketing dashboards where missing a category could mean missing an important gap.
05Combine with automation for ongoing accuracy
Keep this setting in place as your data refreshes, so newly empty or newly active categories stay visible automatically.
Frequently asked questions
Why does Power BI hide categories with no data by default?
Power BI's default behavior only shows categories that have associated data points, which can unintentionally exclude relevant items.
Will showing empty categories clutter my visual?
It can add more items to the axis, but it also ensures viewers see the full picture rather than missing gaps in the data.
Does this setting apply to every visual type?
It's commonly available on chart visuals like bar and column charts, though availability can vary by visual type.
Can this help identify products or regions with zero sales?
Yes, showing items with no data is especially useful for spotting products, regions, or categories with zero activity that might otherwise go unnoticed.
Is this setting difficult to find in Power BI?
It's typically located within the visual's formatting or data options, making it accessible without needing advanced steps.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
