Replacing default text for blank

[qmestu]

Hi,

In one of my dashboards, when i choose a combination of values in slicers some of my measures display "blank". While this is correct, because there aren't any values for some combinations, would it be possible to change the default of blank to something else?

Thanks.

[Ahmedx]

pls try this

= COALESCE([Measure],"Not Supplied" )
-----

replace this [Measure] with your measure

[DOLEARY85 · Accepted solution]

Hi,

You should be able to achieve this by wrapping the measure in an if statment. e.g.

if(isblank(Your measure),"Whatever you want the value to be",Your Measure)

Here's a live example:

Measure 5 = if(isblank(CALCULATE(sum('Table (8)'[column2]),value('Table (8)'[Column1])=01/04/2023)),"There are none",CALCULATE(sum('Table (8)'[column2]),value('Table (8)'[Column1])=01/04/2023))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍