Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
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.
Proud to be a Super User!
I have already replace null with zero in power query editor but not giving desire result.
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.
Proud to be a Super User!