II have a problem making a chart without it changing to "count of" values automatically.

[hima2002]

I want to make a chart for the run date and status but it wont work? How do I do it?here is the chart that i get

[hima2002]

Yes I want my Y axis to be in Text form (either Failed or Success) but it won't let me, it changed to count of.

Is there a way to do that.

[v-rongtiep-msft · Accepted solution]

Hi @hima2002 ,

Unfortunately you cannot change, but you can use numeric values instead of Succeeded and Failed. You can create a column.

column=if('table'[states]="Succeeded",1,if('table'[states]="Failed",0,blank()))

Then you can put the column to the Y axis.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[hima2002]

The end output is as follows:

The runtime on the X-axis, and the Status (Succeeded or Failed) on the Y-Axis.

[v-rongtiep-msft]

Hi @hima2002 ,

The value on Y axis may be Numeric form. It seems the data your provided are text type on the Y axis. Please remove the status to the legend or use the number.

If I have misunderstood your meaning, please provide more details with your desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.