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...
Need Help
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