Forum Discussion

zraopingm's avatar
zraopingm
Icon for Helper IV rankHelper IV
1 year ago
Solved

format zero and blanks with dash

Hello  Is there a way to format zeros and blanks with dash?    thank you  Zoey  
Need Help
  • kpost's avatar
    kpost
    1 year ago

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

     

ExcelMonke's avatar
ExcelMonke
Icon for Impactful Individual rankImpactful Individual
1 year ago

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's avatar
zraopingm
Icon for Helper IV rankHelper IV
1 year ago

Hello, 

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

 

thank you

Zoey