format zero and blanks with dash

[zraopingm]

Hello 

Is there a way to format zeros and blanks with dash? 

thank you 

Zoey

[ExcelMonke]

Glad to have been able to help @zraopingm. I would try @kpost's solution first before moving onto mine - I think it is the better one. 

[zraopingm]

Hello, 

I tried both, COALESCE works perfect( see below), and yes, switch gave me the calssic error. 

thank you

Zoey

[zraopingm]

Thank you all for the great suggestions! I am going to try them on desktop. Meanwhile, I was able to solve the issue via power pivot after some effort,  that is where my final destination.

But I am definitely going to try all of the suggestions you kindly provided to me. I will let you know in one or two days.  Thank you kindly again Zoey

[ExcelMonke]

Hello,

One solution you can consider is using a SWITCH function, like so:

Measure = 

VAR _Calculation = [Calculation]

RETURN
SWITCH(TRUE(),
_Calculation = 0, "-",
_Calculation = "","-",
ISBLANK(_Calculation),"-",
_Calculation
)

[kpost · Accepted solution]

I think this part of your solution will cause an error when you try to compare a number to text using the "equals" comparison?  IE one or the other of these could cause an error 

_Calculation = 0, "-",
_Calculation = "","-",

Therefore I think it is simpler to just use coalesce to resolve blanks to zeros.  I also eliminated the "empty string" option entirely because it was not mentioned by @zraopingm .

Measure_Name = 

VAR _Calculation  = COALESCE([Calculation], 0)

RETURN

IF(_Calculation = 0, "-", _Calculation)

///Mediocre Power BI Advice, but it's free///