Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Treat Null as Zeroes in CLusters and Bars

Just a heads-up for anyone struggling with blank bars in Power BI’s native visuals:

If a value is null (e.g., Gross Revenue PY missing for a country), Power BI simply skips it — no bar, no label, nothing.
There is no built-in setting to display null as 0 in clustered or bar charts, even if you enable “Show items with no data.”

 

Workaround? Use Inforiver Analytics+ (from AppSource):
It includes a “Treat blanks as zero” setting and shows $0 or 0% properly — no DAX needed.

Hopefully, Microsoft adds this logic to native charts soon — it’s a basic need for comparisons.

 

Alestranger_0-1750241401665.jpeg

 

Status: New