Forum Discussion

henry24007's avatar
henry24007
Icon for Helper I rankHelper I
3 years ago

replacing 0 to text in table

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?

Need Help

4 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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's avatar
      henry24007
      Icon for Helper I rankHelper I
      3 years ago

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

       

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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.