0 values are coming as blank for one of the column in Power BI Table visual

[mg01]

Hi Community,

I'm creating one table at the top of table that I imported in Power BI, there is one column that contains few 0 values.
When we are pulling that column to table visual and summarized it as sum 0 values shown as blank.
Is there any way to show this blank value as 0, without creating measure. By measure I was able to achieve it, any alternative so I don't need to create any measure there are around 40 similar columns.

Please find the screenshot attached, refer to column sum of ext_price:

Thanks in advance!!

[danextian]

Hi @mg01 ,

You need replace null values with zero in Power Query in order to achieve your desired result without using a measurre. Although a simple [measure] + 0 should return zero for blanks.

[mg01]

I have already replace null with zero in power query editor but not giving desire result.

[danextian]

You might have no values at all for ext_price - zero or not for these items. Go to data view and try to filter to check.