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