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 ...
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.

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft 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