Forum Discussion

nish2288's avatar
nish2288
Helper I
8 years ago

Replace null value

In the table, i am displaying calculted measure,when measure value is null it display blank. I wanted to display "-" instead of blank. I am using ISBlank function to check values,if its blank then ...
Need Help
Stachu's avatar
Stachu
Community Champion
8 years ago

you can try with FORMAT function

Measure = FORMAT(SUM('Table'[Value])+0,"#,##0.00;;-")

it adds 0 to the regular measure to turn BLANKS into 0s, and then applies custom format to 0s as '-'
the measure type is text afterwards, so not sure if it's gonna work for you