Forum Discussion

Astroraf's avatar
Astroraf
Data Integration
11-19-2025

How to Display Category with 0 Values in Bar/Line Chart?

Hi HamzaJ​ DRay​ , Is there a way to display Categories with no data/zero value in a line or bar chart in Sisense without a widget edit script?  
dashboard design
Data Designer
Display zeros
Zeros
Astroraf's avatar
Astroraf
Data Integration
11-21-2025

Hi HamzaJ​ 

The formula is total of some value lets say total emissions, I want to show all the categories even if they have a zero value. They all coming from the same table.

For the formula: SUM([Total Emissions])

Assumption: (SUM[Total Emissions], ALL(Category)) -> Not sure if this would work. 

HamzaJ's avatar
HamzaJ
Data Integration
11-22-2025

Hey Astroraf​ ,

I know there is a way to do this, but i cant recall the correct formula/steps. I tried it myself but couldnt get it. If there are not to much categories you could try the measured filter route. Otherwise I think a edit on datamodel level is needed.

 Hamza

  • irismaessen's avatar
    irismaessen
    Data Pipeline
    01-20-2026

    Hi Astroraf, HamzaJ

    I no longer have access to a Sisense instance, but I've had luck in the past with adding either +0 (or something like it) to my formula, or using, in the formula, a  value from the dim table that I need to show all the values from. So something like SUM([Total Emissions]) + Count([Category])-1.

    Where Count([Category]) will always be 1 in your pivot/bar chart because it's the category you're splitting on.