How to plot all zero values in scatter chart

[Anonymous]

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! 

[powerBIuser2937]

is ther an update if that worked? For me it is not working

[v-yulgu-msft]

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]

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]

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