Replace 0 with Blank()

[Anonymous]

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!

[henkvankester]

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.. 

[Tiagojk]

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

[texmexdragon2]

@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?

[Greg_Deckler]

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