Forum Discussion
Replacing default text for blank
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.
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 👍
2 Replies
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 👍
pls try this
= COALESCE([Measure],"Not Supplied" )
-----replace this [Measure] with your measure
