Forum Discussion

Ahmad7886's avatar
Ahmad7886
Frequent Visitor
3 years ago

handeling 0 value in power bi table

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?

Need Help

7 Replies

  • eliasayyy's avatar
    eliasayyy
    Icon for Memorable Member rankMemorable Member
    3 years ago

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

    • Ahmad7886's avatar
      Ahmad7886
      Frequent Visitor
      3 years ago

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

      • eliasayyy's avatar
        eliasayyy
        Icon for Memorable Member rankMemorable Member
        3 years ago

        Can you please show me the measure you made?

  • Ahmad7886's avatar
    Ahmad7886
    Frequent Visitor
    3 years ago

    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])