handeling 0 value in power bi table

[Ahmad7886]

I am using power table widget, for some years, data is not available. instead of showing 0.00, i want to show "Data is not available". how to do?

[Ahmad7886]

i ahve created a column, before creating new column i converted the Amount into text. it works, but shows numbers like 3.547934879496. however i needed only two decimal placed

New_Column = if(or(Sheet1[Amount]="0", isblank(Sheet1[Amount])), "NA", Sheet1[Amount])

[aj1973]

@Ahmad7886 

select the measure and make the change here

[eliasayyy]

create a new measure 
if( OR( [ratio] = 0 , ISBLANK([ratio])) , "Data Not Available" , [ratio])

[Ahmad7886]

ratio filed is a numeric field, so its not accepting string "Data Not Available".

[eliasayyy]

Can you please show me the measure you made?

[Ahmad7886]

first i converted numeric filed to text, which shows numeric values like 3.1246984664785. 

new_col = if(or(sheet1[amount]="0", isblank(sheet[amount])), "na", sheet[amount])

this create a new string column with many decimal places

[aj1973]

you need to creat a measure for this sheet1[amount], 

Amount = SUM(sheet1[amount]), change its format like in the image above and then replace into your measure new_col