topic Re: Replace 0 with Blank() in DAX Commands and Tips

Replace 0 with Blank()

Anonymous — Fri, 03 Sep 2021 23:34:31 GMT

Hello all, (simple request)

While everyone has the issue of 'How to replace Blank() with 0' I'm actually trying to do the opposite.

Instead, I would like to 'Replace 0 with Blank()' aka a Blank space value result. (_____)

Below I just want 0 to be a Blank space value

What DAX direction would you recommend for this?

Thanks for any feedback and for pointing me in the right direction!

Re: Replace 0 with Blank()

Greg_Deckler — Sat, 04 Sep 2021 03:16:19 GMT

Anonymous Maybe Column = IF([Min THC%] = 0,BLANK(),[Min THC%])

Re: Replace 0 with Blank()

Anonymous — Fri, 21 Oct 2022 14:18:35 GMT

Greg_Deckler Anonymous I found this post as I am looking for the same thing. However, I'm not sure the answer above is exactly what the original poster was looking for. I think he wanted (as do I), an actual empty cell, with no 0 and not a cell that has the word "Blank" in it. Just an empty cell. Adding the BLANK() seems to add that word to the cell, rather than just returning an empty cell. (and I am looking for a measure, not a column). Any suggestions?

Re: Replace 0 with Blank()

Tiagojk — Wed, 30 Nov 2022 13:45:31 GMT

I recomand you use conditional formatting.

0(Zero) would be colored in write.

1) Values > Conditional Formatting > Background Color

2) Format Style : Rules

Rules - If value : = 0

then = white color

Re: Replace 0 with Blank()

henkvankester — Wed, 30 Nov 2022 13:52:04 GMT

Maybe use a measure instead of a column:

Name measure = IF(SELECTEDVALUE([min THC%] = 0, BLANK(), SELECTEDVALUE([min THC%])).

If min THC% should be summed, then use SUM instead of 'SELECTEDVALUE'.

There is also an option to transform your data, but then you're not using DAX. Change column to text and replace 0 with "" and change back..

Re: Replace 0 with Blank()

gidion — Wed, 09 Oct 2024 02:01:25 GMT

Right click on the column in power query and use the replace values option. Replace '0' with 'null'