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

     

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

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