Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to plot all zero values in scatter chart

Hi, 

 

I have a dataset with some 0 values in it for the metric 'average engagement'. I'm creating a scatter chart, which filters via country for average engagement. I've found that when there is a lot of other data in that country, then the zero values are still represented as a dot. However, when the rest of the average engagement data for the country is sparse, the zero values completely disappear - as shown in the image below. I would like to consistently show the 0 values regardless of the other values in that country's data. Is this possible? My worry is that it is caused by an automated scaling system within power bi that means the zero values dont show up, even as labels, when the difference between values is too large. 

 

I've tried changing the size of the marker and clicked the 'Show items with no data' but neither work.

 

Thanks! 

Need Help

4 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

     

    Instead of placing initial dataset fields into scatter chart, you could show values via measure. For example, if the values displayed on chart dots can be calculated by [Measure1], to show zero, you could add below measure into chart,

    Measure=[Measure1]+0.

     

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for the response,

       

      Would I need to use an aggregate function, like SUM() on the average engagement column? I'm trying to use the formula you wrote above but Power BI is not picking up [Average Engagements] as a column. Also would this formula not just  return a single number? Could I do the same +0 with a calculated column?

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous ,

         

        Would I need to use an aggregate function, like SUM() on the average engagement column? I'm trying to use the formula you wrote above but Power BI is not picking up [Average Engagements] as a column. 

        I think it's depend on your actual data.

         

        Could I do the same +0 with a calculated column?

        Yes. You could have a try.

         

        Best regards,

        Yuliana Gu