Replace Blank with Hyphen in Table

[Anonymous]

Hi,

I just wonder how to replace blank with hyphen in this case below.

The values are from a measure therefore I can't use =IF ( ISBLANK(.

Cheers

Jimmy

[v-easonf-msft]

Hi,  @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread?

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

You can do that then data type need to be matched so the number will become text. So you need to take care of formatting using format function in DAX.

IF(isblank([Measure]),"_",[Measure]&"")