Forum Discussion
undefined
Hi Guyss, I want to show the zero value in line graph. Don't want the power bi to treat zero/null as blank. I have created a measure and using that measure in line graph with months on x-axis. ...
Anonymous , You can add +0 to measure, That will show as blank.
OR Use this option when you want range display to be corrected
0 between range
Measure = var _1= SUM(Opportunity[Opportunity count]) +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))
This solution in not working amitchandak
Still the months having zero value in measure are not being shown in the graph.
Please help.