Forum Discussion

jmiridium's avatar
jmiridium
Helper IV
9 years ago

Value Automatically Added as Count

I am trying to add values to a chart. However, it is not showing the numeric value, it is showing the count. I just want to show the value. How do I do that?

9 Replies

  • Hi jmiridium,

    Check if the column format us number or text, normally when by default the summarize valur is count it's because it's a text column or similar.

    Regards,
    MFelix
    • utsavpatel's avatar
      utsavpatel
      Microsoft Employee

      MFelix v-caliao-msft  jmiridium I have this problem and its still unsolved. Its showing Count when I drop values there. My column datatype is decimal to be accurate. Can you please help me here.

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

    jmiridium,

     

    Add to MFelix, if you column in text format, then please change the column type to value.

     

    Regards,

    Charlie Liao

      • MFelix's avatar
        MFelix
        Super User
        On your visual in the values select the option don't summatize to the field you want to show the values.

        Regards,
        MFelix
  • Anonymous's avatar
    Anonymous
    Not applicable

    utsavpatel  Did you solve the problem? I have the same and do not know how to fix