Forum Discussion

Capstone's avatar
Capstone
Icon for Resolver I rankResolver I
8 years ago

Show zero when there is no data in line chart

I have the following line and stacked column chart. Effective Duration in green and work order count in black are both measures. For days when there is no duration data there is no bar displayed (as I wanted). But for days when there is no work order data I want the line chart to display zero (basically the yellow line instead of the black line). Can Power BI achieve this ? My axis is continuous and I want it that way and not categorical.

 

Need Help

2 Replies

  • Floriankx's avatar
    Floriankx
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Maybe you can try however the black line is calculated to replace empty values by 0.

    IF(ISBLANK([Value]),0,[Value].

     

    Or you try something like

    SUMX(DateTable,Related(Table[Value]))