Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
henry24007
Helper I
Helper I

replacing 0 to text in table

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

henry24007_0-1667880045416.png

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

 

henry24007_1-1667880151130.png

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

4 REPLIES 4
v-yalanwu-msft
Community Support
Community Support

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
Community Support
Community Support

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. 

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

henry24007_0-1667993253248.png

 

When I change it to BLANK()

henry24007_1-1667993314402.png

 

amitchandak
Super User
Super User

@henry24007 , Use replace in power query

 

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.