Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

 

Please help me out.

 

Thanks

Garima

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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))

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      This solution in not working amitchandak 

      Still the months having zero value in measure are not being shown in the graph.

       

      Please help.

  • HarishKM's avatar
    HarishKM
    Super User
    5 years ago

    Anonymous You can replace Null value with 0 then it will popoulate o in chart . Give a try n let me know.