Display Zeros on Bars

[Anonymous]

Hi 

I am trying to create a bar chart where in for some of the weeks/months there is no data however, I would like to display 0 instead of blank. Please help if there any options or workaround.

Thanks,

Krishna.

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

In the column chart zero would be no column in the x-axis.

If you just want to show 0 as lable as well as the other column, then you could create a formula and add +0 at the end of it.

Measure = SUM('Table'[Column2])+0

 

Best Regards,

Jay

[amitchandak]

@Anonymous , +0 in measure can help , but it will show all dates , Try like this example

0 between range
new  Measure = var _1= [measure]+0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
return
CALCULATE(if(max('Calendar'[Date]) <_min || max('Calendar'[Date]) >_max , BLANK(), _1))