Forum Discussion

Ankitapahuja's avatar
Ankitapahuja
Regular Visitor
9 years ago

Percentage values not being treated as numeric values

Hi Team,

 

If a column is in a percentage format, plotting it on a graph is not giving the exact values as displayed, rather it is taking the count of rows. It is not treating it as numeric. Please help

 

Thanks,

Ankita

5 Replies

  • Sean's avatar
    Sean
    Community Champion

    What is the Data Type and also the Format showing - in the Modeling Tab?

     

     

     

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee

    Hi Ankitapahuja,

    The percentage column is a calculated column? Or it is a column in resource data? Could you please share more details or sample data for further analysis?

    Best Regards,
    Angelia

    • Ankitapahuja's avatar
      Ankitapahuja
      Regular Visitor

      Hi,

       

      It is a calculated column in another table and has been merged to the resource data table.

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee

        Hi Ankitapahuja

        If it is nomal when calculated column located in another table ? Did you do other operations when merge the table?

        Best Regards,
        Angelia