How to show all blank values as hyphen or zero

[Anonymous]

Hi I need help from you on how to show the blank values in the card feature as hyphen or blank. 

Pls find the screen shot below.

[PhilipTreacy]

Hi @Anonymous 

Or use ISBLANK() , you can substitute  "" or "-" for 0

IF( ISBLANK([YourMeasureName]) , 0, [YourMeasureName] )

Regards

Phil

[amitchandak]

@Anonymous , add + 0 to you measure 

Example

Sum(Table[value]) +0

Or you can try

if(isblank(Sum(Table[Value])), "-", Sum(Table[Value]) &"")

or

if(isblank(Sum(Table[Value])),0, Sum(Table[Value]) )

[jargana]

I love the "+0" trick, that totally works 😁

eg Sum(Table[value]) +0

[Anonymous]

@PhilipTreacy @amitchandak 

THank you very much. It works but I have a problem that I couldn't put it with dollar sign in front and convert it into the format like "S122K" for example. 

The out put shld be "$162K" in this box. But I could not obtain this kind of output.

[PhilipTreacy · Accepted solution]

@Anonymous 

Click on the Measure in the Fields pane then in the Formatting area of the Ribbon, set the Format to Currency.

The Display Units shoudl be set to Auto so the card shows the K after the number, but if that doesn't show you can manually set it.

In the Format area of the Visualizations pane, open Data label and set Display units accordingly.  Auto should work.

Regards

Phil