Forum Discussion

rashel2002's avatar
rashel2002
Helper II
7 years ago
Solved

force a graph to start from zero

Hi all,   I'm trying to force a graph to start from zero with no success. The graph is based on data tables which doesn't have zero's but empty cells instead. (Those data tables are not the origin...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    7 years ago

    In your measure or column formula, do something like this at then end

     

    IF(ISBLANK(__var),0,__var)

     

    Where __var is a variable that you are calculating (what is currently being returned by the measure/column).

  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi rashel2002,

     

    IF function should work well here. I made one sample for your reference.

     

    Create the measure as below.

     

    Measure = var total = CALCULATE(SUM(Table1[count]))
    return
    IF(ISBLANK(total),0,total)

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank

     

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi rashel2002,

 

IF function should work well here. I made one sample for your reference.

 

Create the measure as below.

 

Measure = var total = CALCULATE(SUM(Table1[count]))
return
IF(ISBLANK(total),0,total)

 

For more details, please check the pbix as attached.

 

Regards,

Frank