Replace £0 with Hyphen

Question

Hi all,&nbsp;Is it possible to replace £0 with hyphens "-"&nbsp;in a table visual?&nbsp;The data are currently showing as whole number currencies.&nbsp;&nbsp;Thanks,

tahreem24 · Accepted Answer

HenryJS&nbsp;,
Create new measure like this:

Measure = IF(SUM('Table'[Currency])=0,"-",SUM('Table'[Currency]))
Then format it as Pound.

&nbsp;

Forum Discussion

Replace £0 with Hyphen

1 Reply

Related content

Replace blank value with hyphen giving error

Replace Blank with Hyphen in Table

Replace NULL

Replacing text , exact

Replace Blank with 0