replacing 0 to text in table

[henry24007]

I would like to replace all the 0 to 'Not provided' 

The above value column that I up-pivoted different columns' values. As you can see there are some 0, I would like to make it to  'Not provided' so that it can be shown in my table/matrix visual

So the above matrix visual with 0 can turn to the text 'not provided'. Is it possible to do that?

[v-yalanwu-msft]

Hi, @henry24007 ；
Sorry I can't reproduce your issue,

If the above one can't help you get the desired result,  It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @henry24007 ;

You could create a measure.

measure =
VAR _sum =
    SUM ( 'table'[value] )
RETURN
    IF ( _sum = 0, "Not provided", FORMAT ( _sum, "0" ) )

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[henry24007]

I don't know why it did not work. It only works when I turned the "not provided" to BLANK()

When I change it to BLANK()

[amitchandak]

@henry24007 , Use replace in power query

Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk