Forum Discussion

forest's avatar
forest
Regular Visitor
8 years ago
Solved

remove count

Hi

 

I'd like to display the action PercentCompleted field in a bar chart.

But, i have the count value

 

does anybody know how to remove this "count" to display the value ?

thank you for helping a beginner

Need Help
  • forest's avatar
    forest
    8 years ago

    thanks MFelix and v-yulgu-msft for your ideas.

    I've just found the solution. I had to convert the percentCompleted field into percent, and it works.

    Event if the field is a numeric value in the SharePoint list, I feel it is converted into text.

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi forest,

     

     

    If you have the version after July you can easaly do this by double clicking the values and then giving it an alias check this link.

     

    Regards,

    MFelix

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi forest,

     

    Is the data type of [PercentCompleted] field numeric or text? In a chart visual, Y-axis only supports numeric values. If adding a text field into Y-axis, it will be counted automatically. Besides, any numeric field added to Y-axis should be aggregated by default. You can choose the aggregation format by clicking the drop down icon. 

     

    If you don't want to aggregate the field, as a workaround, you can create a measure to return relative results.

     

    Regards,
    Yuliana Gu

  • forest's avatar
    forest
    Regular Visitor
    8 years ago

    thanks MFelix and v-yulgu-msft for your ideas.

    I've just found the solution. I had to convert the percentCompleted field into percent, and it works.

    Event if the field is a numeric value in the SharePoint list, I feel it is converted into text.