Display hyphen instead of blank

[StaceyGriffeth]

Hello,

I have BI financial statements and would like to have a hyphen display instead of a blank in case of no data or zero value.  Below is an example of the financial statement:

The columns of numbers are each a measure with a switch statement such that the value for each row is a separate measure.  Here is the measure for the column "AUG 2020":

How can I get hyphens to display in the blanks in the table?

Thanks for your help.

- Stacey

[Anonymous · Accepted solution]

You could wrap each of the switch statements with IF ISBLANK([Nautic...YTD]), "-", FORMAT(DIVIDE...)

that should do it!

[StaceyGriffeth]

Thank you for this suggestion!  I wasn't able to use the "is blank" as in many cases the value was 0, but I was able to do "IF = 0" and get it to return the hyphen.

[Anonymous]

Nice!

[lbendlin]

Push your switch statement into a variable

then 

RETURN IF(0+variable==0,"-",variable)

[nehamaru1985]

HI @lbendlin 

__Cost K$ =
var _CostK = DIVIDE(CALCULATE(sum('Fact'[Allocation]), 'Fact'[Measurement] = "PH"), 1000) + 0
RETURN
IF(0.00 + _CostK = 0.00,"-")

I m trying this measure but its not working .

Getting this issue could you please help .

https://community.fabric.microsoft.com/t5/Desktop/Replace-blank-value-with-hyphen-giving-error/m-p/4...

I have posted my question here please help me to reply there.

[Anonymous]

this works

[StaceyGriffeth]

My switch statement has some intentional blanks (where I want a blank row between figures), so this approach isn't working.  Thank you for offering the suggestion, though.