remove count

[forest]

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

[forest · Accepted solution]

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]

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

[MFelix]

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