Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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.
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()
When I change it to BLANK()
@henry24007 , Use replace in power query
Power Query Replace Value: https://youtu.be/hkZhZbR7Kmk
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |